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.
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.