Transfer data from main sheet to multiple sheets.

Gurushant 1 Posts Thursday December 7, 2017Registration date December 7, 2017 Last seen - Dec 7, 2017 at 10:21 AM - Latest reply: vcoolio 1168 Posts Thursday July 24, 2014Registration dateModeratorStatus May 12, 2018 Last seen
- Dec 8, 2017 at 07:15 AM
I have more then 5000 rows that contains each row have one person details with 15 different column(ex,name.contact no,address.etc), and i have to copy of one person data to next sheet with particular cell those cells are in random place plz help me any one
See more 

Your reply

3 replies

Best answer
vcoolio 1168 Posts Thursday July 24, 2014Registration dateModeratorStatus May 12, 2018 Last seen - Dec 8, 2017 at 07:15 AM
1
Thank you
Hello Gurushant,

Very well. Next, I will need to see your workbook so could you please upload a sample of your workbook to a free file sharing site such as ge.tt or Drop Box and then post the link to your file back here.

Please just upload a sample with a dozen or so rows of data in the main sheet (I don't need to see all 5000 rows of data) and just three or four of the individual sheets. Please use dummy data in the sample and advise which columns in the main sheet you wish the data to come from.

Cheerio,
vcoolio.

Thank you vcoolio 1

has helped 2134 users this month

Respond to vcoolio
vcoolio 1168 Posts Thursday July 24, 2014Registration dateModeratorStatus May 12, 2018 Last seen - Dec 7, 2017 at 06:49 PM
0
Thank you
Hello Gurushant,

Do you mean that you have a main sheet with all the individuals' details, separate worksheets for each individual and you would like to transfer each individual's details to their respective sheet?

Cheerio,
vcoolio.
ya exactly i have details in main sheet and transfer to others separate sheet
Respond to vcoolio