OK attach sample numbers in 2 workbooks (yellow cells) and Workbook "Total" - in each of the workbooks yellow cells are the same: "B5" is "B5" - these documents are invoices and cells are totally same, the idea is when I open a (desired by me) invoice me carry the result of the numbers in the workbook "Total", if in one workbook in cell "D5" = 999999, then let me "paste special value" in the next available cell of the selected column, as in the case for "D5", and starts at column "B9" and down. This applies to all the yellow cells, and is exactly the same.
So the macro will insert in each invoice, so I can activate it, eg a button. Once I open a (desired by me) invoice - I write what I write and push the button, then follow the macro to find the next available cell on the desired column sets the number.
If there is something to make it easier, please ask. Thanks in advance.
Reply With Quote
Bookmarks