Hi David Please refer attached. I have left out many details such as Address Tel, Fax, Attn etc from the Invoices as the details are not availab...
Hi David Is this another template? It is totally different from the one you gave earlier. The macro given my me is not generic and cannot be use...
David_Ng said Sunny. The macro works perfectly. Thanks again... BTW , can we use the Pivot Table, the idea you demonstrate earlier and using the Pa...
Hi David Attached is the final product using Pivot Table (applicable for a single invoice selection only.) The selection button on the Template ...
Hi Dinesh Unfortunately I am unable to help with this as I don't have Excel 2016 . Maybe others could help. Sorry. Sunny
Hi David Refer attached. The macro is called CreateInvoice. Hope this helps. Sunny
Hi Blanka You are welcome. Let us know if you have anymore issues. Sunny
Hi David Lately I have been experimenting to do such thing using a PivotTable instead of a macro. Don't mind if I use you as my 1st "victim" ...
Hi David You should provide a sample Invoice with details. Let us know which column of your data goes to which part of the Invoice. It will be m...
Try watching these webinars. It should give you some good ideas for your dashboard.
Hi Dinesh See if this helps Sunny
Hi Blanka From your file there are actually 3 cells that has blank spaces in them: cells E34, B48, M48 Because of the merged cells, the macro gi...
Hi Catherine You can try =IF(AND(A1+B1)=0,"",MAX(A1,B1)) You did not mention what if A1=B1 and both are not blanks? What do you want to do wi...
Hi Rich Please refer attached. I use a VLOOKUP combined with a PivotTable. Please note that your original formulas in cell E5 and G5 are not ...
Hi Anne Unless there is a specific reason why you need to copy 12 files and then delete their data, I would just delete data from one file and make...