How can i transfer data in a row in a work book to another book

[Closed]
Report
Posts
2
Registration date
Thursday November 14, 2013
Status
Member
Last seen
November 15, 2013
-
Posts
2
Registration date
Thursday November 14, 2013
Status
Member
Last seen
November 15, 2013
-
Hi,
I will be downloading data each day which consists 150 rows. Each row contains a data set pertaining to an individual item.

Each of these items (150) will have a dedicated worksheets to maintain up to date data.
How can i automatically up date data from day file to summary files of each individual item daily automatically?

Thank you,

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can have a macro do that. If you post sample books one may be able to help more
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Thursday November 14, 2013
Status
Member
Last seen
November 15, 2013

Hi rizvisa 1 Thank you for the reply. Where can i attach the sample books?