Hi I have a problem trying to link 2 cells on different workbooks.
I have workbook 1 which has sheet 1 as blank invoice with a bit of vba run by clicking a button.
Sheet 2 is a customer database populated with data when sheet 1 button has been clicked.
Workbook 2 is an invoice generated by sheet 1 when the button is clicked on the first workbook and saved in a folder on C:
On workbook 1 sheet 2 (customer database) I have a string of code (view invoice) which when clicked will open the related invoice from the C: drive folder.
Now to my problem, I need to have a cell on the customer database change when I update a cell in the generated invoice (total) i.e. I have to change the cost and this change will automatically update the cell with the cost in workbook 1 sheet 2 ( customer database)
I need this link to be linked to the relevant invoice since the database will move down a line as each invoice is generated.
Can this be done? I have looked at using hyperlinks but I have to manually add it to each line in the database.
Hopefully you can understand what I'm trying to explain
Thanks William
Bookmarks