Copying a link

  • Thread starter Thread starter jijy
  • Start date Start date
J

jijy

Hi,

I have 2 sheets in a workbook -Sheet 1 and sheet 2. I have data in
sheet 2 as follows:

Row ColumnA
1 data1
2 data2
3 data3

Now I want to put a formula in Sheet 1 to get the data from Sheet 2 as
follows:

Row ColumnA
1 =Sheet1!A1
2 -----
3 =Sheet1!A2
4 -----
5 =Sheet1!A3

On sheet 1 , I am skipping a row when copying the formula and because
of this I am getting the formula all messed up.

Please help.

Thanks
 

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

Formula help 3
which function to use 2
Splitting data from one spreadsheet into multiple spreadsheets 2
EXCEL - IF(IFERROR(VLOOKUP question 0
Match and delete rows on two different sheets from reference numbers 4
Drop Down with dynamic named range offsheet source list 14
Copying Formulas 5
Copying cells from one sheet to another 5

Back
Top