Difference between =Sheet1!A1 and =+Sheet1!A2 ?

**praveenmathew** · 10-24-2014, 03:43 AM

Saw these 2 uses. I inserted this into A2 of Sheet 2, both worked fine. I dragged down and excel auto filled it for both as well. Is there any difference?

**zbor** · 10-24-2014, 03:51 AM

No. You don't need "+" infront of formulae.

Difference between =Sheet1!A1 and =+Sheet1!A2 ?

LinkBack

Thread Tools

Rate This Thread

Display

Difference between =Sheet1!A1 and =+Sheet1!A2 ?

Re: Difference between =Sheet1!A1 and =+Sheet1!A2 ?

Thread Information

Users Browsing this Thread

Similar Threads

move data from sheet1 to sheet2 based on date in column1 of sheet1

=+Sheet1!A1+Sheet1!B1+Sheet1!C1 macro to convert all linked ref to Values

merge book1,sheet1,book2,sheet1,book3,sheet1 ect

[SOLVED] Take Data From Column on Sheet1 and Insert Into Next Blank Row on Sheet2 Then Clear Sheet1

[SOLVED] Copying selective data from sheet2 to sheet1 based on the selection made in sheet1.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions