Forum Discussion

LauraDaisy's avatar
LauraDaisy
Copper Contributor
May 01, 2018

Sorting data

hi, this is my data (theres 707 lines in total) Transaction Status Transaction ID Transaction Date RD Reference Amount Declined - Bank declined 10 01/11/2017 119664 ...
excel
Macros & VBA
LauraDaisy's avatar
LauraDaisy
Copper Contributor
May 09, 2018

So I tried  this (thankyou v.much :) Logaraj Sekar )

 

I tried it on a new set of data - it worked but pulled out 30 CSV files.

 

When I did it manually there are only 2 spreadsheets.

 

Any ideas? I dont know anything about VBA code so not sure where to start.

 

Thanks

:)

Logaraj Sekar's avatar
Logaraj Sekar
Steel Contributor
May 09, 2018

Hi Laura,

 

Based on the RD reference, i created macro. So it will count no of RD references (without duplication).

 

If RD reference count is 30, it will create 30 Sheets. In case you need change, explain it i will do changes in macro.