Split master sheet info to new sheet based on day

S

Serrax

New Member
Joined
Oct 10, 2005
Messages
7
Office Version
  1. 2019
Platform
  1. MacOS
Hello! I wonder if you could help me, I have a big worksheet with flights information for several months, I need to split that information on new sheets, one per day, so to create first the new sheet and assign the date (ie. 11-Feb-23 on the tab name) and from the master sheet, copy and paste all rows with that day (ie. 11-Feb-23) into the new tab (also copying the headers) and do the same for each single day from the master worksheet. The Day is always on column F. My intention is to have a single sheet named with the day and with only the information for that particular day.... I have attach the master worksheet.

Thanks in advance for your help!!

1678952769351.png
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.
Sort by date Sort by votes
You may want to use XL2BB to show us your Master. Speaking only for myself, I have no desire to re-type your data and to guess on how it is formatted on your sheet. That said, I would try to help if that were the case. Additionally, you may also want to finish your profile by telling us the platform and Excel Version you are using, that way a solution provided could be tailored to your version of Excel.
 
Upvote 0
Hi Again

I have managed to install XL2BB, pls find a mini sheet. Sorry I was working from my office laptop and not able to install any add-ins. Thanks to you all fr your help!!
Working Master DOC.xlsx
ABCDEFGHIJKLMNOPQRSTUV
1AREASTATIONROUTEFLIGHT NBR DAYDATESTDSTADIRECTIONA/CCANXUPDATEBY WHOMDOORSChocks offDL1DL2DL3TREPORTSENT BY/DATECOMMENTS
2EASTNCBRLFNCBPS472Sat2/11/236:0509:10OutboundB787
3EASTAMDRLFAMDPS456Sat2/11/236:2009:55OutboundB788
4EASTAMDRLFAMDPS458Sat2/11/237:3511:10OutboundB789
5EASTIBGIBGRLFPS491Sat2/11/2317:3019:30InboundB794
6EASTAMDAMDRLFPS463Sat2/11/2319:0520:20InboundB795
7EASTNCBRLFNCBPS482Sat2/11/2319:2022:25OutboundB796
8EASTNCBNCBRLFPS489Sat2/11/2320:2022:00InboundB797
9EASTAMDAMDRLFPS465Sat2/11/2320:4522:00InboundB798
10EASTNCBRLFNCBPS472Sun2/12/236:0509:10OutboundB799
11EASTAMDRLFAMDPS456Sun2/12/236:2009:55OutboundB800
12EASTNCBRLFNCBPS478Sun2/12/237:2510:30OutboundB801
13EASTAMDRLFAMDPS458Sun2/12/237:3511:10OutboundB802
14EASTNCBNCBRLFPS477Sun2/12/237:4009:20InboundB803
15EASTAMDRLFAMDPS466Sun2/12/238:2511:55OutboundB804
16EASTLVCRLFLVCPS408Sun2/12/239:2512:50OutboundB805
17EASTNCBNCBRLFPS473Sun2/12/2310:0011:30InboundB806
18EASTNCBRLFNCBPS474Sun2/12/2310:3013:35OutboundB807
19EASTAMDAMDRLFPS457Sun2/12/2310:4012:10InboundB808
20EASTNCBNCBRLFPS479Sun2/12/2311:1512:40InboundB809
21EASTAMDAMDRLFPS459Sun2/12/2312:0013:30InboundB810
22EASTAMDAMDRLFPS467Sun2/12/2312:4514:15InboundB811
23EASTIBGRLFIBGPS490Sun2/12/2312:5516:45OutboundB812
24EASTNCBRLFNCBPS480Sun2/12/2313:1516:20OutboundB813
25EASTLVCLVCRLFPS409Sun2/12/2313:5015:30InboundB814
26EASTPGARLFPGAPS412Sun2/12/2313:5517:50OutboundB815
27EASTNCBNCBRLFPS475Sun2/12/2314:3516:00InboundB816
28EASTNCBNCBRLFPS479Mon2/13/2311:1512:40InboundB839
29CENTRALAMDAMDRLFPS459Mon2/13/2312:0013:30InboundB840
30CENTRALIBGRLFIBGPS490Mon2/13/2312:5516:45OutboundB841
31EASTNCBRLFNCBPS480Mon2/13/2313:1516:20OutboundB842
32CENTRALAMDRLFAMDPS460Mon2/13/2313:2016:55OutboundB843
33EASTLVCLVCRLFPS409Mon2/13/2314:0015:40InboundB844
34EASTNCBNCBRLFPS475Mon2/13/2314:2015:45InboundB845
35CENTRALAMDRLFAMDPS462Mon2/13/2315:0018:30OutboundB846
36EASTNCBRLFNCBPS470Mon2/13/2315:2018:15OutboundB847
37CENTRALPGAPGARLFPS413Mon2/13/2315:2517:20InboundB848
38CENTRALAMDRLFAMDPS464Mon2/13/2316:2519:50OutboundB849
39EASTNCBRLFNCBPS488Mon2/13/2316:3519:50OutboundB850
40EASTNCBNCBRLFPS481Mon2/13/2317:1518:45InboundB851
41CENTRALIBGIBGRLFPS491Mon2/13/2317:3019:30InboundB852
42CENTRALAMDAMDRLFPS461Mon2/13/2317:5019:20InboundB853
43EASTNCBNCBRLFPS471Mon2/13/2319:0520:25InboundB854
44EASTNCBRLFNCBPS482Mon2/13/2319:1022:15OutboundB855
45CENTRALAMDAMDRLFPS463Mon2/13/2319:2020:35InboundB856
46EASTNCBNCBRLFPS489Mon2/13/2320:4022:20InboundB857
47CENTRALAMDAMDRLFPS465Mon2/13/2320:4021:55InboundB858
48CENTRALAMDRLFAMDPS456Tue2/14/236:2009:55OutboundB859
49CENTRALAMDRLFAMDPS458Tue2/14/237:3511:10OutboundB860
50EASTNCBNCBRLFPS477Tue2/14/237:5009:30InboundB861
51CENTRALAMDRLFAMDPS466Tue2/14/238:2011:50OutboundB862
52EASTNCBRLFNCBPS476Tue2/14/238:2511:30OutboundB863
Master
Cell Formulas
RangeFormula
A28:A52A28=IF(OR(B28="PGA",B28="AMD",B28="TFS",B28="LPA",B28="SVQ",B28="ACE",B28="IBG"),"CENTRAL", "EAST")
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:J9952Expression=$K2="x"textNO
S1:S8157Cell Value="N"textNO
S1:S8157Cell Value="Y"textNO
 
Last edited:
Upvote 0
It is nice to see that you posted your sheet with XL2BB, that should help get an answer. Unfortunately, I know nothing about VBA for MacOS, except that there are differences from Windows. Hopefully, another member of the Forum will jump in and help.
 
Upvote 0
igold said:
It is nice to see that you posted your sheet with XL2BB, that should help get an answer. Unfortunately, I know nothing about VBA for MacOS, except that there are differences from Windows. Hopefully, another member of the Forum will jump in and help.
Click to expand...
Thanks for your help, sorry I am not an expert on this and just trying from time to time
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question
VBA to hide current sheet, then create new sheet from template
Replies
3
Views
164
Micron
M
Z
  • Question
Excel table To split or not to split??
Replies
5
Views
275
Fluff
Fluff
A
  • Question
Worksheet from a template using a master list but protecting existing worksheets
Replies
0
Views
211
Alfalfa166
A
I
  • Question
VBA - Copy Sheet from a workbook saved as a date - paste to specifically named sheet in another workbook based on the date
Replies
2
Views
187
Insurance Dave
I
H
  • Question
Update master sheet automatically when changes are made to split sheet VBA
Replies
0
Views
315
helplessnoobatexcel
H

Forum statistics

Threads
1,214,421
Messages
6,119,392
Members
448,891
Latest member
tpierce

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top