P
patrabil
--------------------------------------------------------------------------------
Can anyone advise..how I can create an ongoing "log" to automaticall
populate inv#, date, customer, and amount, pulling data from three othe
worksheets using identical templates (for 1st, 2nd and final invoices)
Since they are only templates, every time I create a new custome
invoice by reediting , it changes the previous entry in my "log" sheet
the way I currently have it set up. Obviously, the invoice# is the on
unique factor throughout. All 4 worksheets are within the same workbook
I've attached workbook, so you can see it's not too complex, but I'
still in the early learning stage.
It would be great if there were some way to tell the "log" sheet t
extract the date, name & amount no matter what worksheet contained th
source data, by inputting the invoice number alone (in Col "A"). I d
have a formula (using vlookup) unique to each of the existing
worksheets to generate an invoice#, so I'm not sure if this coul
interfere..although there's no problem to copy/paste. Any help
anyone??
PA
Can anyone advise..how I can create an ongoing "log" to automaticall
populate inv#, date, customer, and amount, pulling data from three othe
worksheets using identical templates (for 1st, 2nd and final invoices)
Since they are only templates, every time I create a new custome
invoice by reediting , it changes the previous entry in my "log" sheet
the way I currently have it set up. Obviously, the invoice# is the on
unique factor throughout. All 4 worksheets are within the same workbook
I've attached workbook, so you can see it's not too complex, but I'
still in the early learning stage.
It would be great if there were some way to tell the "log" sheet t
extract the date, name & amount no matter what worksheet contained th
source data, by inputting the invoice number alone (in Col "A"). I d
have a formula (using vlookup) unique to each of the existing
worksheets to generate an invoice#, so I'm not sure if this coul
interfere..although there's no problem to copy/paste. Any help
anyone??
PA