Hi everyone,
This may entail one or more macro's but I'll try and explain what I'm tryng to achieve.
In one spreadsheet "Masterlist.xlsx", the data I want to copy is in the following columns (there is additional data on each row but I don't need that)
Column A - My Reference
Column B - Feed
Column C - Notification Date
Column D - Vendor
Column E - Vendor ID
Column F - Severity
Column G - Description
Column H - Product
In my second spreadsheet "Form.xlsx" I to achieve the following:
For each record matching a specified date (can make inputting the date as part of the Macro operation) I need create a copy of the tab called 'template'.
Then I need to do the following:
In C3 insert the output from Column A
In C4 insert the output from Column B
In G3 insert the output from Column C
In G4 insert the output from Column D
In G5 insert the output from Column E
In B7 insert the output from Column G
In C16 insert the output from Column F
In B23 insert the output from Column H
Then I want to rename the Tab the same as Cell C3 and loop until a tab is created for each record with a date matching that originally specified.
Then I want to save the output with a filename yyyymmdd - Alerts.xlsx
I used to be fairly familiar with macro's but lack of practice has made me a tad rusty. If this requires more than one macro I have no problems with putting them all together.
Thanking you in anticipation.
Terry
Bookmarks