aowroj
11-03-2013, 10:09 AM
Hi All,
Please send me a VBA macro to solve the below issue.
I have a master file with approx 35+ Sheets with data. The unique value on every sheets has A1 column (DCP Name).
please provide me a macro that do the below work:
1. Copy the unique value (filter A column & copy the unique data from column A to end) from every sheets (Sheet 1 to 35)
2. Paste it to new file every sheets
3. E-Mail it to party wise (Outlook 2007)
The DCP Name & Emil Ids find the other one file & match cases do the step 1 to 3.
Please Help.......................................
thanx
Please send me a VBA macro to solve the below issue.
I have a master file with approx 35+ Sheets with data. The unique value on every sheets has A1 column (DCP Name).
please provide me a macro that do the below work:
1. Copy the unique value (filter A column & copy the unique data from column A to end) from every sheets (Sheet 1 to 35)
2. Paste it to new file every sheets
3. E-Mail it to party wise (Outlook 2007)
The DCP Name & Emil Ids find the other one file & match cases do the step 1 to 3.
Please Help.......................................
thanx