Previous Topic Next Topic

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 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Vikas
Feb 24, 2013 at 11:00 PM
Hi rizvisa1

Its the later part.
A single project's daily information about that project needs to be pulled in.
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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