Selection of Data from multiple sheet

Closed
Report
Posts
1
Registration date
Saturday February 23, 2013
Status
Member
Last seen
February 23, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I am facing a problem, regarding selection of specific rows from multiple sheet in a single workbook.

Details:

I have a workbook with date wise sheets.
sheets are named as dates.
Every sheet has some projects and are updated regularly on daily basis.
Few projects get added and deleted.

Now I want to create a new sheet where i want to track a single project's day wise entry.

Can you please help me out on this one.

I will be grateful.

Thanks in Advance
.



1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Hi
Is this tracking for all projects or is it a case where you would enter a project and then daily information about that projects gets pulled in ?
Hi rizvisa1

Its the later part.
A single project's daily information about that project needs to be pulled in.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Do this first
1. start macro recorder
2. insert a new sheet
3. go to one of the "Dated" sheet
4. apply filter for a project
5. copy all visible row
6 paste rows in newly created sheet
7. repeat 3, 4, 5 and 6 for one more "Dated" sheet]
8 stop macro
9. copy and paste the recorded macro back here.