I have an excel file with multiple sheets all with the same table schema. I need a macro made that will search each sheet and copy over any records from that sheet to a summary sheet. I have already made a macro that is sort of working, except it is copying over the table header which I do not want to happen, it is also copying over some blank fields which i also do not want to happen. Finally i would like the macro to run when the sheet is opened.
Hi, I am good at Excel and vba. Looking forward to work on the project and discuss in the chat. I have experience in transferring the data from worksheets to summary sheet using macro. -Chandra