podder
01-15-2018, 03:15 AM
Hi,
I have asked a similar question before but want to make the macro better so here goes.
I want to copy a row of data as such: Column D, E, F, H and I (omitting G). The rows are copied down to the last value in column D
The data must then go into the worksheet that is stated in Column A (tab name has been inserted into column A), these values must be pasted in Row 14A through to 14E in each worksheet.
Any help would be appreciated
Thanks
I have asked a similar question before but want to make the macro better so here goes.
I want to copy a row of data as such: Column D, E, F, H and I (omitting G). The rows are copied down to the last value in column D
The data must then go into the worksheet that is stated in Column A (tab name has been inserted into column A), these values must be pasted in Row 14A through to 14E in each worksheet.
Any help would be appreciated
Thanks