Hi

I've looked over the forum and tried searching, but alas, I couldn't
find an entry or link to a really simple invoice system whereby I can
create a template and when I fill in the total, this figure is
displayed in a second sheet in the next available cell

eg

Invoice basically is

Date - Ref - Client - GST - Total

so the second sheet would take these 5 entries and place the cell
contents in a single row (next available)

Is this possible (easy or hard?)

many thanks in advance


--
hiker
------------------------------------------------------------------------
hiker's Profile: http://www.excelforum.com/member.php...o&userid=23871
View this thread: http://www.excelforum.com/showthread...hreadid=375138

Have you tried using MS Access.

Chris

"hiker" wrote:


Hi

I've looked over the forum and tried searching, but alas, I couldn't
find an entry or link to a really simple invoice system whereby I can
create a template and when I fill in the total, this figure is
displayed in a second sheet in the next available cell

eg

Invoice basically is

Date - Ref - Client - GST - Total

so the second sheet would take these 5 entries and place the cell
contents in a single row (next available)

Is this possible (easy or hard?)

many thanks in advance


--
hiker
------------------------------------------------------------------------
hiker's Profile: http://www.excelforum.com/member.php...o&userid=23871
View this thread: http://www.excelforum.com/showthread...hreadid=375138

i'm unclear as to what you are trying to do.

do you want sheet 1 to have those blanks and you put them in and then
those numbers are automatically populated in an invoice "archive" and
then if you change the numbers on sheet1, the history will still stay
there?

if this is what you are trying to do, you can put a button on page 1
that after you enter the invoice information it copies those numbers
into the second page as values, not as formulas.


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=375138