Copying Worksheet data

J

John Bordieri

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
 
I

Ian

=Sheet1!A1

Copy the formula down the column and the reference to row 1 will change to
2, 3, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Excel lookup across entire workbook 1
Make Chart refer to user defined worksheet 4
Copy a worksheet to a new workbook 6
Email Worksheet Question 3
copying a style from one worksheet to another in the same workbook 1

Top