Hi

If you clicked on custome name or invoice it had a drop down list,
pick the one you want and all the fields filled in with that ivoice
information.

-- this can be achieved with Data / Validation and the VLOOKUP function


Or if you scrolled down the spread sheet and clicked on one of the
rows it filled in the fields.

-- this needs VBA code to implement it - have you worked with VBA at all?

i have a sample invoicing workbook that uses Data / Validation and VLOOKUP
to populate an invoice that you might be interested in ... if so, email me
direct julied_ng at hcts dot net dot au

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"WTG" wrote in message
...

Thanks for the reply Julie,

The top half of the screen looked like an invoice. ( ie.

customer name _____________ Date _________
Customer address __________ Invoice # ___________

Units Description Cost Total
1 fan - black $10.00 $10.00
2 This or That $ 5.00 $10.00
SubTotal
GST
PST
Total.


The second half of the screen was a spread sheet ( ie
A B C E
1 Customer Address Fan-black 1
2 Customer Address
...ect

If you clicked on custome name or invoice it had a drop down list,
pick the one you want and all the fields filled in with that ivoice
information.

Or if you scrolled down the spread sheet and clicked on one of the
rows it filled in the fields.




On Fri, 15 Apr 2005 00:13:51 +0800, "JulieD"
wrote:

Hi

i guess it could be done in excel - using VBA .. .however, an alternative
that you might like to check out, is select a record in a list (like the
customer invoices) and choose data / form ....

with your original request, could you describe in more detail how the top
section looked and the bottom section ... was the screen split (windows /
split) or what the top "frozen" (windows / freeze pane) or did the top bit
look a bit like the data / form mentioned above?