Dear all
My first post so hi to all, I know the very basics of excel so any help welcome.
I have a small business that over a period of time people build up a bill with me, So I have started an excel spreadsheet with headings along the top of the expenditure and names down the side to which in the cells I add the amount.
I want to print a bill, so I set up a second sheet with the graphics etc on and have brought the information across by using the =Sheet1!C1 formula.
The above doesn't work due to not knowing how to change the bill as a whole on the second sheet. I move the cells and the whole formula changes etc
However what I want to do is add the name off the customer to the second sheet and the bill come across.
Am I doing this correctly is this the easiest way? Any advice greatly received
Thank you
Bookmarks