hi all,
really hoping someone can help me here as i just cant seem to find the answer online after days of looking
I'm trying to create a macro that will automatically move data from one sheet to another based on the values in two columns
so the sheet that holds all the data is called "FRONT" and then i have 31 tabs for each day of the prospective month named 1st, 2nd, 3rd and so on
on each tab for the days of the month there are 16 individual tables that correlate to 16 different vehicles
so if a row on the "FRONT" sheet has the 1st in column E and lets say BD65YSK in column G I would like the data copied from cells A,B,D,J and K copied to the table for the relevant
tab inside the relevant table that corresponds to that vehicle and i would like the copied data to then appear in unison with no gaps
i have managed to get this to work using just the REG but as you can imagine that is no good as it will just send all the data to the one sheet instead of splitting it up based on what day of the month
really hoping someone can help me here as i just cant seem to find the answer online after days of looking
I'm trying to create a macro that will automatically move data from one sheet to another based on the values in two columns
so the sheet that holds all the data is called "FRONT" and then i have 31 tabs for each day of the prospective month named 1st, 2nd, 3rd and so on
on each tab for the days of the month there are 16 individual tables that correlate to 16 different vehicles
so if a row on the "FRONT" sheet has the 1st in column E and lets say BD65YSK in column G I would like the data copied from cells A,B,D,J and K copied to the table for the relevant
tab inside the relevant table that corresponds to that vehicle and i would like the copied data to then appear in unison with no gaps
i have managed to get this to work using just the REG but as you can imagine that is no good as it will just send all the data to the one sheet instead of splitting it up based on what day of the month
