Modifying Dataset and Copying Over to Sheets

[ultralightbeam]

Hi, I'm new to making and using macros, I was wondering if anyone can help me program the following if its not too much work. I've tried making something similar with recording, but it doesnt come out right. Any help would be appreciated!

Background:
Dataset in 1 Sheet with ~200K lines, looking to replace some of the dataset based on lookup tables and output them by region (separate tabs)
Macro To do:
1. Using raw data set (tab called "Page1"), replace fields in column K based on lookups in table called "Business"
2. Each Tab is a Region Name (Canada, USA, etc). If Tab name matches Column AK, copy each line starting on row 10 for the following:
- Column AK (from "Page1")
- Column AE (from "Page1")
- Column AG (from "Page1")
- Column K (from "Page1")
- Leave as blank
- Look up Column T, if maching value as "Jan", then paste value from Column N


Sorry! please delete if its duplicate. I posted this in the wrong section! Thank you!

[AliGW]

Duplicates are not allowed so this thread is closed.

Continue here: https://www.excelforum.com/excel-pro...to-sheets.html