Selection of Data from multiple sheet

Closed
vikas.w.nandanwar
Posts
1
Registration date
Saturday February 23, 2013
Status
Member
Last seen
February 23, 2013
- Feb 23, 2013 at 06:39 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Feb 25, 2013 at 07:11 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 24, 2013 at 08:11 AM
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 ?
0
Hi rizvisa1

Its the later part.
A single project's daily information about that project needs to be pulled in.
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Feb 25, 2013 at 07:11 AM
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.
0