create sheets based on cell values with corresponding data

**VinodN** · 02-29-2016, 01:35 AM

Hi,
Need help with a macro.
I have a sheet with the below data

Sr.No Name Days Grp Status
1 abc 1234 1 no
1 abc 1234 1 no
1 abc 1234 1 no
2 abc 1234 1 no
2 abc 1234 1 no
2 abc 1234 1 no
2 abc 1234 1 no
3 abc 1234 1 no
3 abc 1234 1 no
3 abc 1234 1 no
4 abc 1234 1 no
4 abc 1234 1 no
5 abc 1234 1 no
5 abc 1234 1 no

I need to create sheets based on the Sr. No. Column and the corresponding data to be copied on to the respective sheets.
For. Eg: create sheet with name 1 and copy all the data related to 1 in that sheet and a sub total for column Days. which means sheet with name 1 should contain all the three rows of sr. no.1 and total for column days which will be 3702.

Subsequently create sheets for the other numbers upto 5.

Request your help on this.

Thanks in advance.

Regards,
Vinod

**sourabhg98** · 02-29-2016, 02:10 AM

The sheet containing data should be named "Data".
Use this macro-

Please Login or Register  to view this content.

Check attached for reference.

**VinodN** · 02-29-2016, 03:03 AM

Hi Sourabh,

Thank you so much with this. I have another data which is in a different sequence. I am trying to use the similar logic but am not able to work out. Can you please help.

I have attached the data.
Site Pay Code Date and Time Dash To Time Pay Level Hours Type Rate Hours (Time)
6197 7435 01/01/2016 15:00 - 23:00: Guard Level 2 Bank Holiday 13.40 8.00
6197 7435 02/01/2016 07:00 - 15:00: Guard Level 2 Regular 6.70 8.00
6197 7435 03/01/2016 07:00 - 15:00: Guard Level 2 Regular 6.70 8.00
6197 7435 04/01/2016 18:00 - 23:00: Guard Level 2 Regular 6.70 5.00
6196 7435 05/01/2016 18:00 - 23:00: Guard Level 2 Regular 6.70 5.00
6196 7435 06/01/2016 18:00 - 23:00: Guard Level 2 Regular 6.70 5.00
6196 7435 07/01/2016 18:00 - 23:00: Guard Level 2 Regular 6.70 5.00
6196 7435 08/01/2016 18:00 - 23:00: Guard Level 2 Regular 6.70 5.00
6198 7435 09/01/2016 07:00 - 15:00: Guard Level 2 Regular 6.70 8.00
6198 7435 10/01/2016 07:00 - 15:00: Guard Level 2 Regular 6.70 8.00
6198 7435 11/01/2016 18:00 - 23:00: Guard Level 2 Regular 6.70 5.00
6199 8956 31/01/2016 06:30 - 07:00: Site Visit Billable Not Payable 0.00 0.50
6199 8956 31/01/2016 22:00 - 22:30: Site Visit Billable Not Payable 0.00 0.50
6199 8957 22/01/2016 01:05 - 01:35: Mobile Super Billable Not Payable 0.00 0.50

Here the sheets are to be created based on the first column and the total required for the last column, but all the other data is also to be populated in the respective sheet.

In your earlier script i am a bit getting confused with the target commands. Apologies i am not that good at macro.

Can you please help.

Thanks in advance.

Regards,
Vinod

**sourabhg98** · 02-29-2016, 03:26 AM

Okay, edited-

Please Login or Register  to view this content.

**VinodN** · 02-29-2016, 04:29 AM

Thank you once again. This time it has worked. Just one last query. The output of column E (To Time) is not coming as per the original data sheet. Can anything be done on that.

Thanks.

Regards,
Vinod

**sourabhg98** · 02-29-2016, 05:26 AM

Okay, that was a formatting issue try this-

Please Login or Register  to view this content.

Check attached for reference.

**VinodN** · 02-29-2016, 07:16 AM

Hi Sourabh,

Just one more help. Sorry to bother you. I tried with the formatting part but the command is going into loop and doing a formatting after every line is updated because of which it is taking time. Also need to give the data range till the data not beyond that. Also confused with where to insert the formatting script.

I have attached the output file after formatting how it should appear.
The data should be in borders
The headers should be bold
The Total word and the number should be in bold.

Your help will be highly appreciated.

Thanks.

Regards,
Vinod

create sheets based on cell values with corresponding data

LinkBack

Thread Tools

Rate This Thread

Display

create sheets based on cell values with corresponding data

Re: create sheets based on cell values with corresponding data

Re: create sheets based on cell values with corresponding data

Re: create sheets based on cell values with corresponding data

Re: create sheets based on cell values with corresponding data

Re: create sheets based on cell values with corresponding data

Re: create sheets based on cell values with corresponding data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Create new sheets and copy/paste data based on values in a column or columns

[SOLVED] VBA: Create new sheets based on cell value and copy data

Copy data from 2 sheets and create new sheets based on values. Add up values with same nam

[SOLVED] Filter data on sheet1, create, and paste into new sheets based on cell value

How to create and populate sheets based upon cell values in master sheet?

[SOLVED] Add Data in Different Sheets and Result in Master Sheet based on Cell Values

Create/Name sheets based upon values

Bookmarks

Bookmarks

Posting Permissions