Advanced Excel help

loopyloulou_3

Just wondering how to do the following in Excel

I have 2 sheets

One has formulas on and one looks like a "bill"

I need to make a sheet in which I can enter the data i.e. client name, address etc and the items to go on the invoice ie. description, amount, VAT etc

I then want this information to show in a presentable format on the "bill sheet" which I can then print and give to the client.

Many thnaks

Lou

pjb007

So you want details from one sheet to display in another there are two ways of doing this.

Formaule like this
=Sheet1!A1

or

Select the cell you want to place the data in, press = select the correct sheet select the data and press enter.