How to copy data into template (worksheet) based-on unique column value

Gruhby

New Member
Joined
Jul 12, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Forum statistics

Threads
1,144,232
Messages
5,723,148
Members
422,479
Latest member
Mr_Confused

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top