uday
Member
Hi,
I have two trackers. One is Main Tracker and another is Sub Tracker. The purpose of the main tracker is to keep all the data together from Sub tracker.
The Sub Tracker data is not fixed with row count. That is every day users are filing up the data with date and I need to copy-paste the latest added data to Main tracker. Also keeping the old recorded data in Main tracker.
If any new entry not added by any user and it is already there in Main Tracker, then no need copy-paste to Main tracker. Only need to add the data which is newly added with date to main tracker.
Now, Same date can be mentioned with different rows with different items. The data only should be copy paste by the newly added date not by the items type. i.e. in Sujan Tab 10-04-2018 date mentioned in two rows. That means macro should pick up two lines for this case.
(Pain Area - Another important thing is the Sub Tracker workbook downloaded from Sharepoint and not saved in particular folder. There are 5 sub trackers in sharepoint. Each time I need to download the excel file from Sharepoint to get the latest data and paste it onto Main tracker by Sheet name.)
I have already figured it out how to open the file from Sharepoint each time.
In Main tracker data should transfer by the sheet name from the sub tracker. After copying the data from Active Sub Tracker Macro should automatically close the active sub Tracker workbook.
I have already given an example in main tracker what I am trying to achieve.
Macro Module should be contains in Main Tracker.
Please let me know if any other information is required.
Regards,
Roy
▬▬▬▬▬▬▬▬▬ Mod edit : thread closed, a new duplicate thread was created !
I have two trackers. One is Main Tracker and another is Sub Tracker. The purpose of the main tracker is to keep all the data together from Sub tracker.
The Sub Tracker data is not fixed with row count. That is every day users are filing up the data with date and I need to copy-paste the latest added data to Main tracker. Also keeping the old recorded data in Main tracker.
If any new entry not added by any user and it is already there in Main Tracker, then no need copy-paste to Main tracker. Only need to add the data which is newly added with date to main tracker.
Now, Same date can be mentioned with different rows with different items. The data only should be copy paste by the newly added date not by the items type. i.e. in Sujan Tab 10-04-2018 date mentioned in two rows. That means macro should pick up two lines for this case.
(Pain Area - Another important thing is the Sub Tracker workbook downloaded from Sharepoint and not saved in particular folder. There are 5 sub trackers in sharepoint. Each time I need to download the excel file from Sharepoint to get the latest data and paste it onto Main tracker by Sheet name.)
I have already figured it out how to open the file from Sharepoint each time.
In Main tracker data should transfer by the sheet name from the sub tracker. After copying the data from Active Sub Tracker Macro should automatically close the active sub Tracker workbook.
I have already given an example in main tracker what I am trying to achieve.
Macro Module should be contains in Main Tracker.
Please let me know if any other information is required.
Regards,
Roy
▬▬▬▬▬▬▬▬▬ Mod edit : thread closed, a new duplicate thread was created !