Hi all,
Can someone help I would like to know if there is a way I can copy the value of a cell from one worksheet to another without copy and paste.
I have attached a workbook.
I would like to move the value in cell F9 in the Monthly Invoice sheet to B2 in the Annual Accounts sheet and so on without having to switch back and forth between the sheets.
The monthly invoice sheet will have numerous customers as will the annual accounts.
Hope this makes sense.
Many thanks
Tom
Bookmarks