Hi PaulaS Glad that helps Sunny Kow
Hi PaulaS This attachment can update either entire column or specific row in column Q (Date Revised). Just modify the codes. Sunny Kow
Hi PaulaS See if this is what you are looking for. From your reply above, I am not sure if you want to populate the entire column Q (Date Revise...
Hi Amy From my understanding of your codes, you want to do the following based on what is in column AM : 1) If it contains an error then delete ...
Hi Amy Maybe you could explain what you are actually trying to achieve. The only code I can make sense of is you are deleting rows with error in...
Hi PaulaS Refer my attachment. It uses a worksheet change event to find the row that was changed and add today's date to column 1 of that row. ...
Hi rathanak Did you mean Ordinal numbers? I have attached a file with a sample but the formula is only good up to 50th orders. Hopefully it w...
Hi Jimmy Glad to know I was able to help. I have no idea why the macro recorder failed to record the semi colon and why VBA needed it to format ...
Hi Higgins Try this Sub Red() Selection.NumberFormat = "#,##0_);[Red](#,##0);" End Sub You are just short of a semicolon at the end. S...
I totally agree with Mynda. Use a helper column. It will save you a lot of trouble Sunny Kow
Hi rathanak Please post sample worksheet with enough data and expected result for easy understanding Sunny Kow
Hi Rathanak I have modified the formula given by Mynda to DBuck earlier. 1) The date had been modified to show dd/mm/yyyy 2) Instead of "x" i...
Hi Mynda Thanks. Glad I am able to help out. Sunny
Hi Tim If that is what you want then I would suggest using a Pivot Table. Refer to my attachment. Sunny Kow
Hi Tim I am not too sure what you wanted. By looking at your data, my guess is you want to filter a drug (example Drug A) and expect to see the ...