=IF(Sheet1!D3<"",Sheet1!D3,"")
Put this formula in a box on you invoice sheet
The change the "Sheet1" and the D3 to what you need sheet and cell you need
the formula to read from, if it is blank, the formula will also leave it
blank until there is anything typed in.
HTH
"texasx96" wrote:
I've never created a macro before, and I'm not 100% sure that it's what
I need here.
Here's what I'm trying to accomplish....
I've created a spreadsheet with several imbedded workbooks and about
10 columns of data on each workbook.
I have an invoice form, containing about 5 columns of data.
What I hope to accomplish is that appropriate data entered in my
workbooks is automatically placed and consolidated on my invoice sheet
in the appropriate boxes.
I would really appreciate any help that someone would be willing to
provide. I'm getting fairly proficient with formulas, but right now
macros are new territory for me.
Thanks for any guidance that you can provide.
**** I should probably note that I'm using excel '97*******
--
texasx96
------------------------------------------------------------------------
texasx96's Profile: http://www.excelforum.com/member.php...o&userid=33786
View this thread: http://www.excelforum.com/showthread...hreadid=535550