sample.xlsx
hi in attached file i want to turn sheet 1 into sheet 2
so i need to first take the number in brackets in sheet one and paste them to sheet to in right column and then take the desceiption and the end balance as well.
this is only done where the is a value bigger than 0.00 in end balance
is this possible
Hi,
I'd be inclined to use some helper columns like H:J in the attached, then either just use a simple Data Advanced Filter copy to another location with a criteria range for Ending Balance <>0, and filter the H:J range to sheet 2.
Alternatively copy H:J to sheet2 as values, then filter on the Ending balance to show all zeros, select all the filtered rows and delete them.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
its going to be copied into a nother book and then has to be uploaded to a system. will that formula still work with the way i need it to be done
Hi,
Don't see why not. Formulae may contain other workbook references as well as sheet and cell refs.
Output in sheet3
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks