Ctrl find, copy and pasting help please (Macro code needed)

Originally Posted by arlu1201

I have a question for you - is there any specific reason why you are searching the entries from excel spreadsheet.... in example file and not vice versa? You can search for all the columns from example in the big file and then copy the data. Whichever columns are not found, you can choose to put a 0 or leave blank. What do you say?

Hi Arlu

No - no particular reason other than I am a novice and wanted to ensure that all header items had been searched for in the example file so as all data is captured. The example file is variable and changes month to month so I want the macro to place all the data contained within the excel spreadsheet. The remaining data not copied across will be used in another spreadsheet for which i will build another macro for.

The end result is for all the example data to go into the excel spreadsheet. I just need to make sure each line doesnt get mixed up as it relates to one employee. The next line data is for a nother employee

Hope this makes sense - thanks for your help on this

Originally Posted by arlu1201

You have mentioned that the example file changes each time. Do the headers change too? Or just that today there might be data in 5 columns and the next time 8?

The excel spreadsheet has all the possible payroll components where as the example file will only have the payroll components processed in say this period. The headers will be identically named and will not change from month to month but this month 5 of the components could be used which is what will populate in the example file or next month all the header rows from the excel spreadsheet could be used in which case all payroll components/header names will appear in the example file

Originally Posted by arlu1201

Ok, since its all inclusive, it will be better to search the headers from the example file in the excel file and not vice-versa. This way, you will not get errors. And incase there are some fields which are not populated, we can have the macro key in blanks or 0.

Once the header is found, the entire column can be copied right away. You do not need to go row wise, so this can avoid possible errors.

Thanks Arlu - but the variable sheet will have different headers in it from month to month - any of those headers in the variable sheet can be any of those on the fixed sheet so that is why I couldn't do it the other way. How can I check that any header (which will change from month to month) is in the fixed excel fixed spreadsheet ? what code could I use ?

Many thanks

Originally Posted by arlu1201

I am working out something for you. I have a question. When the data is found, should it be copied to the next available row in the excel spreadsheet or just below the header?

The header row in both spreadsheet will be contant so the data when the header/payroll component is found then I want the data pasted directly below the header row so from row 2 onwards

many thanks