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 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - Jul 25, 2015 at 02:40 AM
vcoolio Posts 1411 Registration date Thursday July 24, 2014 Status Moderator Last seen September 6, 2024 - 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
- Start survey - Download - Horror
- Google sheet right to left - Guide
- Download automatically while roaming - Guide
- Windows network commands cheat sheet - Guide
1 response
vcoolio
Posts
1411
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 6, 2024
262
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.
