Link to home
Start Free TrialLog in
Avatar of Wilder1626
Wilder1626Flag for Canada

asked on

Extract data in multiple xls file

Hello all

I would need your help on a macro where it will create multiple xls file based on all the different value from column A row 3 going down.

User generated image
Based on this picture, it would create 4 different xls file names on each value from column A.

A file named 167, another named 213...

In each file, i could have the 2 first row on the file + all the data from the value of column a

Ex:
for 167, it would create an xls file and add the row 1 and 2+ 3 other rows of data that match 167.

How can i do that?

Thanks
Test-extract.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Wilder1626

ASKER

Hi imnorie

I'm seeing that it only transfer the first row. How can i add all row for the same number from column A

Thanks again
Sorry the problem was me.

all good.

Thank you so much for your help
Avatar of Norie
Norie

Change Unique:=True to Unique:=False.
Thanks again
Hi,

How can we achieve this using a vbscript?

thanks,
Aditya