Automatically Copy New Survey Data to Another Sheet
Closed
BopPunkGreg
Posts
1
Registration date
Tuesday July 14, 2015
Status
Member
Last seen
July 28, 2015
-
Jul 14, 2015 at 01:33 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jul 25, 2015 at 02:40 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jul 25, 2015 at 02:40 AM
Related:
- Automatically Copy New Survey Data to Another Sheet
- Transfer data from one excel worksheet to another automatically - Guide
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- Tmobile data check - Guide
- Pc restarts automatically - Guide
1 response
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Jul 25, 2015 at 02:40 AM
Jul 25, 2015 at 02:40 AM
Hello Bop,
As you are concatenating from row 2 in Sheet 1, in Sheet 2, start your formula in row 2 and then drag it down. You will then see that the row numbers in the formula will match on both sheets. Reserve row 1 for any headings.
This should solve the incorrect increment for you.
I hope that this helps.
Cheerio,
vcoolio.
As you are concatenating from row 2 in Sheet 1, in Sheet 2, start your formula in row 2 and then drag it down. You will then see that the row numbers in the formula will match on both sheets. Reserve row 1 for any headings.
This should solve the incorrect increment for you.
I hope that this helps.
Cheerio,
vcoolio.