Hello,
Good luck with this challenge... I haven't been able to get everything to come together (might need to create two macros).
The goal is as follows:
To copy data (multiple rows) from one sheet (Master Tab) to the template file for each unique value in column A of the 'Master' tab.
Assumptions:
1) 'Master' tab is the first worksheet in the file and contains many columns of data (i.e. A1-G1000)
2) 'Template_File' is the second worksheet in the file.
Macro Must Do The Following:
A) Create a new template worksheet & rename that worksheet for each unique value in column A of the 'Master' tab.
B) Select the unique values in column A and paste them in new template_file (cell B5)
Bonus Help:
I. I don't use all the data into the Master sheet. If there is a way to rearrange the data (or only select specific columns) based on a list.
-- (i.e. I only want to select specific values from column A)
II. Macro's contain some sort of self check system.
III. Being able to import Data from another workbook into the Master tab and have the imported excel file name be placed in Master tab cell A1 (shift everything down a row).
Please let me know if you need more details.
Thank you in advance for taking the time to read this and helping me out!
Gruhby
Good luck with this challenge... I haven't been able to get everything to come together (might need to create two macros).
The goal is as follows:
To copy data (multiple rows) from one sheet (Master Tab) to the template file for each unique value in column A of the 'Master' tab.
Assumptions:
1) 'Master' tab is the first worksheet in the file and contains many columns of data (i.e. A1-G1000)
2) 'Template_File' is the second worksheet in the file.
Macro Must Do The Following:
A) Create a new template worksheet & rename that worksheet for each unique value in column A of the 'Master' tab.
B) Select the unique values in column A and paste them in new template_file (cell B5)
Bonus Help:
I. I don't use all the data into the Master sheet. If there is a way to rearrange the data (or only select specific columns) based on a list.
-- (i.e. I only want to select specific values from column A)
II. Macro's contain some sort of self check system.
III. Being able to import Data from another workbook into the Master tab and have the imported excel file name be placed in Master tab cell A1 (shift everything down a row).
Please let me know if you need more details.
Thank you in advance for taking the time to read this and helping me out!
Gruhby