Copy data from Main sheet to target sheets according to row header and target sheet header

Hello,

Thanks to people on this forum I received the following code:

Please Login or Register  to view this content.

It works perfectly, but only for a single day. It takes the data from my index sheet and places it next the names in the corresponding sheets, which have the same name as the top row.

As soon as I import data with more than 1 day, or where someone has been off in the middle of the week or not logged in,... anything that would interrupt with a 5 day system (5 days, 5 figures), the data becomes "corrupted" after running the macro.

In the sample sheets that I have attached, are 2 names from which I removed 2 days of entries. All Target sheets have a date on top. The idea is obviously that all data is corresponding with name and date (which is fine if it is a single entry).

On the "AfterSample" I manually added the expected result to clarify the bunch of words above.

Any help on the code, or advice is greatly appreciated.

Try this one

Please Login or Register  to view this content.

Kind regards
Leo

Hello LeoTaxi,

Thank you for your response.

I imported your code into my full workbook and it debugged.

Please Login or Register  to view this content.

Do I leave this at 3, as my original code has it as 2(usernames)

Please Login or Register  to view this content.

For n = 9 , Do I change this to back to 2 or leave at 9? Originally n was pointing to the usernames in col 2

Please Login or Register  to view this content.

"mycol" returns "error2042".

Code made for this file where it is working,

from row 9 because the first username is @ row 9
columns from 3 to 7, those columns have the data to transfer


Kind regards
Leo

Hello Leo...

My mistake. Row 2-8 are hidden as I used those to "populate" the top row on the target sheets (date). Should have mentioned that.
After adding the dates manually (which I can do via a formula to update), the code works perfect.

Just one extra question.

Please Login or Register  to view this content.

This changes my formulaes in the G column (which are dates). Is this supposed to happen? I am asking this as I am newish to VBA and never seen VBA change a formula within a given cell.

Regards,

Red

Hello Red,

yes this supposed to happen, with this date ( not the 1 in column A, or the previus in column G) we find the column in other sheets.


Kind regards
Leo