Hi Everyone
I looking for a way to delete duplicate data but I don’t want to lose my worksheet’s formatting. Is there a way to do that?
Here is an example of what I’m doing and what I need.
I have a worksheet with three columns; company name, account total and account balance
Co 1 - 10,000 – 5,000
Co 2 – 8,000 – 4,000
Co 3 – 7,000 – 3,000
Co 4 – 6,000 – 2,000
Co 5 – 5,000 – 1,000
This data is brought in to this sheet (say summary sheet) via a macro that pulls the latest data from the company’s designated sheet within the same workbook. I also have another macro that omits (doesn’t display in the summary sheet) the company data when the balance is zero. So say company 3 paid their balance of $3,000; my current summary sheet would look like this:
Co 1 - 10,000 – 5,000
Co 2 – 8,000 – 4,000
Co 4 – 6,000 – 2,000
Co 5 – 5,000 – 1,000
Co 5 – 5,000 – 1,000
What I’d like it to look like is this:
Co 1 - 10,000 – 5,000
Co 2 – 8,000 – 4,000
Co 4 – 6,000 – 2,000
Co 5 – 5,000 – 1,000
EC/B – EC/B – EC/B
FYI – EC/B = empty cell or blank with formatting
This sheet contains formatting; primarily borders and shading that I don’t want to lose. Also, companies will be added and deleted as they acquire or pay their debt, so the solution needs to be dynamic. I was thinking of maybe a conditional statement that checks for duplicates within a specified range and if it finds any duplicates, will clear the contents of the cells of column A, B and C of that row. Is that even possible? if so, would that keep the formatting?
I tried using the remove duplicates method but it also deleted the formatting.
Any ideas are greatly appreciated
Thanks
Bookmarks