PDA

View Full Version : Copy to multiple sheet based on cell value criteria



tlchan
04-30-2016, 12:31 AM
Hi there,

I wish to accomplish a separate ledger for each currency ("USD","SGD" & etc ) a raw data ("Txn Data"). I managed to accomplish only for 1 currency.

How to complete for all currency to void multiple setting of worksheet name and last row for each sheet. The naming of each currency tab based on column A of in ("Txn Data")


Attached workbook the first currency example.