=Sheet1!A1
Copy the formula down the column and the reference to row 1 will change to
2, 3, etc.
--
Ian
--
"John Bordieri" <(E-Mail Removed)> wrote in message
news:ZKUBi.227057$(E-Mail Removed)...
> Hi,
> Is it possible to have data that is typed in a worksheet to be added to
> another worksheet of the same workbook.
> I have my inventory worksheet with pricing and other info needed. I also
> have another worksheet in the same workbook but all I need is the pricing
> and the description added to my second worksheet. Is there a formula to do
> this?
>
> Thank you,
> John
>
|