Hi
I have a bank statement with 12 000 rows with daily transactions for the whole month
id like to separate each days transactions into a separate sheet in the same workbook
eg id have x separate sheets in my workbook depending on how many different dates (duplicates) there are in my bank statement
id obviously also like to be able to remove the original duplicate date
i hope this is coherent
Thanks
Meshwiires
Hello...
Can you explain with sample data...
Click *, if my suggestion helps you. Have a good day!!
sure, please see attached just for the first 3 days of the month
i like each days' transactions to appear on their own sheet in the same workbook
and the sheet name to be the day e.g 01 , 02 , 03
thanks
example.xlsx
the date format is "yyyymmdd". Pls confirm...
yes thats correct yyyymmddOriginally Posted by jraj1106
just to add that the "duplicate" here is the date and not the transaction description
Check this out. I hope this is what you wanted...
example.xlsm
ABSOLUTELY BRILLIANT
to call you a legend would be an understatement
thanks so much
i have quite a few vba questions hopefully ill post a few more
thanks again
LEGEND!!!
Sure anytime... Happy to have solved your problem... Thanks for your feedback...
Pls click the STAR below the post...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks