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 ?
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.
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.

Similar discussions

Cannot download multiple files at once in WhatsApp Web
nemonavicusrino -
dannygzus -

4 responses
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response