Hi Vic You can refer to an example here: Like what Anders mentioned above, it is not fool-proof. Good luck. Sunny
Hi Chandra OK so you want to repeat the Date, Supplier's Name and PO number. Attached is the macro (ReptPONo) that will do the job. You will ...
OK No problem.
Hi Maurizio Thanks for your feedback. Not every issue requires a macro solution. Some good old formulas entered manually can usually solve the p...
Try If Not IsDate(Cells(i,1)) Then
Hi Maurizio Why do you want to use a macro to add the formula? Can't you just key in manually? Are you trying to SUM or COUNT? What is the aster...
Hi Chandra You should create a new topic to ask your own question. From your attachment I can't see a difference between the two sheets. What...
Are you referring to column A with multiple criteria or multiple column with criteria? Either way you can use OR to check multiple criteria. Exa...
Hi Themba Try this Sub DelRows() Dim LastRow As Long Dim i As Long LastRow = Cells(Rows.Count, "A").End(xlUp).Row Application.ScreenUpdating =...
Hi Danielle If you are not able to supply the file them maybe you can supply the output format based on your sample data above. At the moment we...
Hi Danielle Are you trying to extract multiple records for the same employee number? e.g. Employee#100282 will display 3 records as per your exa...
Hi Vic See if this helps. Note that I am unable to add the formula into cell I2 as you have an opening balance there. I suggest you start you...
You are welcome
Hi Carlos 1) Copy the required range eg A2:AA12 2) Select a cell eg A14 3) Select Home - Paste - Paste Special - Transpose Hope this helps...
Hi Susan Please post a sample file with some data and the results you are getting with your formula. Sunny