Copying Data from Sheet 1 to Sheet 2 and adding rows- Code Needed

[bamaisgreat]

Starting at A17 on Sheet 1 I have a row of data that I need the data from columns A,B,C,D and G (Column B is a specific ship date) copied to one of the ranges in sheet 2 that contain the 4 quaters of the year. The date in coulmn B determines which range of the quartely ranges it goes into. On sheet 2 the 4 quaters of the year 1st Quater Jan-March 2024 Range A4-Q4, 2nd Quarter April-June 2024 Range A6-Q6, 3rd Quarter July-Sep 2024 Range A8-Q8, 4th Quarter Oct-Dec 2024 Range A8-Q10. Once the data has been entered on sheet 1 I need it add another row with the same formatting as the row above it so the next line of data can be entered. On sheet 2 I also need a row added with the same formatting as the row above it to which ever quaterly ranges the data was copied into.

 

[bamaisgreat]

Starting at A17 on Sheet 1 I have a row of data that I need the data from columns A,B,C,D and G (Column B is a specific ship date) copied to one of the ranges in sheet 2 that contain the 4 quaters of the year. The date in coulmn B determines which range of the quartely ranges it goes into. On sheet 2 the 4 quaters of the year 1st Quater Jan-March 2024 Range A4-Q4, 2nd Quarter April-June 2024 Range A6-Q6, 3rd Quarter July-Sep 2024 Range A8-Q8, 4th Quarter Oct-Dec 2024 Range A8-Q10. Once the data has been entered on sheet 1 I need it add another row with the same formatting as the row above it so the next line of data can be entered. On sheet 2 I also need a row added with the same formatting as the row above it to which ever quaterly ranges the data was copied into.

WORKING ON Franklin Job Review .xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
15							F- Jobs
16	Project	Ship Date	Customer	Job Type	Status	% Comp	Notes	CONTRACT PRICE	Invoiced %	AMOUNT BILLED TO DATE	Margin	ESTIMATED GROSS PROFIT	COSTS TO DATE	FMI Cost	GG Cost
17	F3685	Dec-24	BigBee	F3685-PTW Line	Shipped / Not Closed		Complete		95%	$0.00
18
19
20
21
22
23
24
25
26
Sheet 1

Cell Formulas
Range	Formula
J17	J17	=H17*I17

WORKING ON Franklin Job Review .xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1							FMI's Current Backlong of Major Projects
2	Project	Ship Date	Customer	Job Type	Status	% Comp	Notes	Engineering		Purchasing		Machine Shop		Fab Shop		Assembly
3							1st Quarter Jan-Mar 2024
4
5							2nd Quarter April-June 2024
6
7							3rd Quarter July-Sep 2024
8
9							4th Quarter Oct-Dec 2024
10
11
Sheet 2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O4	Other Type	Color scale		NO
O4	Other Type	Color scale		NO
O4	Other Type	Color scale		NO
O4	Other Type	Color scale		NO
O4	Other Type	Color scale		NO
O4	Other Type	Color scale		NO
Q4	Other Type	Color scale		NO
Q4	Other Type	Color scale		NO
Q4	Other Type	Color scale		NO
Q4	Other Type	Color scale		NO
Q4	Other Type	Color scale		NO
Q4	Other Type	Color scale		NO
M4	Other Type	Color scale		NO
M4	Other Type	Color scale		NO
M4	Other Type	Color scale		NO
M4	Other Type	Color scale		NO
M4	Other Type	Color scale		NO
M4	Other Type	Color scale		NO
K4	Other Type	Color scale		NO
K4	Other Type	Color scale		NO
K4	Other Type	Color scale		NO
K4	Other Type	Color scale		NO
K4	Other Type	Color scale		NO
K4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Other Type	Color scale		NO
I4	Cell Value	=1	text	NO
K4	Other Type	Color scale		NO
K4	Other Type	Color scale		NO
K4	Other Type	Color scale		NO
K4	Cell Value	=1	text	NO
M4	Other Type	Color scale		NO
M4	Other Type	Color scale		NO
M4	Other Type	Color scale		NO
M4	Cell Value	=1	text	NO
O4	Other Type	Color scale		NO
O4	Other Type	Color scale		NO
O4	Other Type	Color scale		NO
O4	Cell Value	=1	text	NO
Q4	Other Type	Color scale		NO
Q4	Other Type	Color scale		NO
Q4	Other Type	Color scale		NO
Q4	Cell Value	=1	text	NO

 

[mumps]

I'm not sure I understood correctly, but try:

Sub CopyData()
    Application.ScreenUpdating = False
    Dim rng As Range, Val As String, fnd As Range, srcWS As Worksheet, desWS As Worksheet
    Set srcWS = Sheets("Sheet1")
    Set desWS = Sheets("Sheet2")
    For Each rng In srcWS.Range("B17", srcWS.Range("B" & Rows.Count).End(xlUp))
        If rng >= DateSerial(Year(rng), 1, 1) And rng <= DateSerial(Year(rng), 3, 31) Then
            Val = "1st"
        ElseIf rng >= DateSerial(Year(rng), 4, 1) And rng <= DateSerial(Year(rng), 6, 30) Then
            Val = "2nd"
        ElseIf rng >= DateSerial(Year(rng), 7, 1) And rng <= DateSerial(Year(rng), 9, 30) Then
            Val = "3rd"
        ElseIf rng >= DateSerial(Year(rng), 10, 1) And rng <= DateSerial(Year(rng), 12, 31) Then
            Val = "4th"
        End If
        With desWS
            Set fnd = .Range("G:G").Find(Val, LookIn:=xlValues, lookat:=xlPart)
            .Rows(fnd.Row + 1).EntireRow.Insert
            .Range("A" & fnd.Row + 1).Resize(, 4).Value = srcWS.Range("A" & rng.Row).Resize(, 4).Value
            .Range("G" & fnd.Row + 1).Value = srcWS.Range("G" & rng.Row).Value
        End With
    Next rng
    Application.ScreenUpdating = True
End Sub

 

[bamaisgreat]

Please disregard I had it saved as a workbook that didnt accept macros.

Sorry about that

Thank you for your reply. Im a little rusty on properly explaining. I entered the code into a module but im not seeing it copy the cells to sheet 2. I re-entered the data on sheet 1 row 17 and entered the ship date in B17 but it didnt put it in any of yearly quater on sheet 2. Should I copy the code you provided into the sheet code? Not sure what Im missing but im sure its the way I was explaining it.

Thanks

 

[mumps]

I used the two sheets you posted. I placed the macro into a regular code module, ran it and it worked properly. Did you run the macro manually?

 

[bamaisgreat]

I used the two sheets you posted. I placed the macro into a regular code module, ran it and it worked properly. Did you run the macro manually?

I spoke to soon. I was thinking it would do it automatically but when I actually ran the macro it worked as intended. Im assuming I could change the Application.ScreenUpdating to true and it would run when i entered the date but Im guessing if I dont have all the data put into the cells that are to be copied they will just be blank

 

[mumps]

You could have the data copied over automatically after you enter the date. You would have to enter all the other data first and the date last. Is this what you want?

 

[bamaisgreat]

I think its doing a few things that I didnt think about. Im going to enter some data and see if I can explain a couple things that might could be tweaked in the code.

Thanks again mumps for you help I will be back intouch tomorrow

 

[bamaisgreat]

After entering several lines of data and run the code Ive seen a few things Its doing that I didnt think about. If you could modify code that would be great. I will add copies of the mini sheets below that hava data in them so you see how the sheet will grow overtime. Here is the things I see.

*Could the trigger the code to run when the date is enter in column B?

*On sheet1 there will be more data added to each row dailey so when the code runs it needs to only copy the data from that row in Columns A,B,C & D to sheet 2

* When the code adds the next row on sheet 2 could it copy the formatting that the data came from on sheet1 instead or copying the formatting from the row above it.

*Sometimes I may have to edit some of the data on one of the rows in sheet1, could you have it where it will only update that same row of data in sheet2 when the date is re-entered without it copying all the rows that have the date in it again?

WORKING ON Franklin Job Review .xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1							FMI's Current Backlong of Projects
2	Project	Ship Date	Customer	Job Type	Status	% Comp	Notes	CONTRACT PRICE	Invoiced %	AMOUNT BILLED TO DATE	Margin	ESTIMATED GROSS PROFIT	COSTS TO DATE	FMI Cost	GG Cost
3	Ret- Jobs
4	F2048-RET2		Allied Lock
5	F2559AL-RET2
6	F2612-RET5
7	F2646-RET3
8	F3105-RET4
9	F3208-RET4
10	F3348-RET5
11	F3544-RET2
12	F3616A-RET1
13
14
15							F- Jobs
16	Project	Ship Date	Customer	Job Type	Status	% Comp	Notes	CONTRACT PRICE	Invoiced %	AMOUNT BILLED TO DATE	Margin	ESTIMATED GROSS PROFIT	COSTS TO DATE	FMI Cost	GG Cost
17	F3685	Dec-24	BigBee	F3685-PTW Line	Shipped / Not Closed		Roll Tide		95%	$0.00
18	F3668	Dec-23	Acero	F3668-Material Handling Line	Shipped / Not Closed		Load containers next week		50%
19	F3669	Apr-24	ACERO	F3669-20" Flange Lines	Fab/ Machine				50%	$0.00
20	F3670	Feb-24	ACERO	F3670-PTW Line	In Machine Shop				50%	$0.00
21	F3697	Jan-24	New Millenium	F3697-4330 Angle Shear	In Machine Shop		begin		35%	$0.00
22	F3699	May-24	Standard Structures	F3699- PTW 72	Fab		Released with F3670		35%	$0.00
23	F3700	May-24	Standard Structures	F3700-Plasma System	Fab				35%	$0.00
24	F3701	May-24	Standard Structures	F3701-Plate/Flange	Fab		Released with F3690		35%	$0.00
25	F3703	Jan-24	CNH Industries	F3703-Angle Line	In Machine Shop				60%	$0.00
26	F3704	Apr-24	Ideal Steel	F3704-PTW	Fab/ Machine				35%	$0.00
27	F3705	Feb-24	Chief Buildings	F3705- Plate/Flange Line	Fab/ Machine				35%	$0.00
28	F3707	Mar-24	ASTA Door	F3707-Angle Line with Coopers	Programming				35%	$0.00
29	F3710	Nov-24	Lucas Metals	F3710-PTW 72	Engineering				35%	$0.00
30	F3711	Nov-24	Lucas Metals	F3711-Plasma System	Engineering				35%	$0.00
31	F3712	Nov-24	Lucas Metals	F3712-Plate/Flange Line	Engineering				35%	$0.00
32	F3713	Dec-24	Valley Joist	F3713-Valley Joist Angle Line	Engineering				35%	$0.00
33	F3714	Dec-24	Vulcraft - Texas	F3714-Long Span Angle Line	Engineering				35%	$0.00
34	F3715	Jan-25	Central States	F3715-Plasma Line	Engineering				35%	$0.00
35	F3716	Jan-25	Central States	F3716-PTW 72	Engineering				35%	$0.00
36	F3717	Jan-25	Central States	F3717-Plate/Flange Line	Engineering				35%	$0.00
37	F3718	Aug-24	Siemans	F3718-BusBar	Programming				20%	$0.00
38	F3719	Aug-24	Siemans	F3719-BusBar	Engineering				20%	$0.00
39	F3720	Aug-24	Siemans	F3720-BusBar	Engineering				20%	$0.00
40	F3721	Aug-24	Siemans	F3721-BusBar	Engineering				20%	$0.00
41	F3722	Oct-24	Siemans	F3722-BusBar	Engineering				20%	$0.00
42	F3723	Oct-24	Siemans	F3723-BusBar	Engineering				20%	$0.00
43	F3724	Oct-24	Siemans	F3724-BusBar	Engineering				20%	$0.00
44	F3725	Mar-24	Bham Rail	F3725 - Rail Press	Engineering				35%	$0.00
45	F3727	Mar-25	ACI Buildings Expansion	F3727-72x240 slat table	Engineering				35%	$0.00
46	F3728	Mar-25	ACI Buildings Expansion	F3728-Plate/Flange Line	Engineering				35%	$0.00
47	F3729	Mar-25	ACI Buildings Expansion	F3729- PTW 72	Engineering				35%	$0.00
48	F3730	Jan-24	SBS Buildings	F3730- Web seamers	Engineering				35%	$0.00
49	F3731	Dec-24	AIG Controls	F3731- Shears / Nothers / Punches	Engineering					$0.00
50
51
52
53
54
55
56
57
58
59
60
61
Sheet1

Cell Formulas
Range	Formula
J17,J19:J49	J17	=H17*I17

WORKING ON Franklin Job Review .xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1							FMI's Current Backlong of Major Projects
2	Project	Ship Date	Customer	Job Type	Status	% Comp	Notes	Engineering		Purchasing		Machine Shop		Fab Shop		Assembly
3							1st Quarter Jan-Mar 2024
4	F3730	Jan-24	SBS Buildings	F3730- Web seamers
5	F3729	Mar-25	ACI Buildings Expansion	F3729- PTW 72
6	F3728	Mar-25	ACI Buildings Expansion	F3728-Plate/Flange Line
7	F3727	Mar-25	ACI Buildings Expansion	F3727-72x240 slat table
8	F3725	Mar-24	Bham Rail	F3725 - Rail Press
9	F3717	Jan-25	Central States	F3717-Plate/Flange Line
10	F3716	Jan-25	Central States	F3716-PTW 72
11	F3715	Jan-25	Central States	F3715-Plasma Line
12	F3707	Mar-24	ASTA Door	F3707-Angle Line with Coopers
13	F3705	Feb-24	Chief Buildings	F3705- Plate/Flange Line
14	F3703	Jan-24	CNH Industries	F3703-Angle Line
15	F3697	Jan-24	New Millenium	F3697-4330 Angle Shear			begin
16	F3670	Feb-24	ACERO	F3670-PTW Line
17
18							2nd Quarter April-June 2024
19	F3704	Apr-24	Ideal Steel	F3704-PTW
20	F3701	May-24	Standard Structures	F3701-Plate/Flange			Released with F3690
21	F3700	May-24	Standard Structures	F3700-Plasma System
22	F3699	May-24	Standard Structures	F3699- PTW 72			Released with F3670
23	F3669	Apr-24	ACERO	F3669-20" Flange Lines
24
25							3rd Quarter July-Sep 2024
26	F3721	Aug-24	Siemans	F3721-BusBar
27	F3720	Aug-24	Siemans	F3720-BusBar
28	F3719	Aug-24	Siemans	F3719-BusBar
29	F3718	Aug-24	Siemans	F3718-BusBar
30
31							4th Quarter Oct-Dec 2024
32	F3731	Dec-24	AIG Controls	F3731- Shears / Nothers / Punches
33	F3724	Oct-24	Siemans	F3724-BusBar
34	F3723	Oct-24	Siemans	F3723-BusBar
35	F3722	Oct-24	Siemans	F3722-BusBar
36	F3714	Dec-24	Vulcraft - Texas	F3714-Long Span Angle Line
37	F3713	Dec-24	Valley Joist	F3713-Valley Joist Angle Line
38	F3712	Nov-24	Lucas Metals	F3712-Plate/Flange Line
39	F3711	Nov-24	Lucas Metals	F3711-Plasma System
40	F3710	Nov-24	Lucas Metals	F3710-PTW 72
41	F3668	Dec-23	Acero	F3668-Material Handling Line			Load containers next week
42	F3685	Dec-24	BigBee	F3685-PTW Line			Complete
43
44
45
46
47
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O4:O16	Other Type	Color scale		NO
O4:O16	Other Type	Color scale		NO
O4:O16	Other Type	Color scale		NO
O4:O16	Other Type	Color scale		NO
O4:O16	Other Type	Color scale		NO
O4:O16	Other Type	Color scale		NO
Q4:Q16	Other Type	Color scale		NO
Q4:Q16	Other Type	Color scale		NO
Q4:Q16	Other Type	Color scale		NO
Q4:Q16	Other Type	Color scale		NO
Q4:Q16	Other Type	Color scale		NO
Q4:Q16	Other Type	Color scale		NO
M4:M16	Other Type	Color scale		NO
M4:M16	Other Type	Color scale		NO
M4:M16	Other Type	Color scale		NO
M4:M16	Other Type	Color scale		NO
M4:M16	Other Type	Color scale		NO
M4:M16	Other Type	Color scale		NO
K4:K16	Other Type	Color scale		NO
K4:K16	Other Type	Color scale		NO
K4:K16	Other Type	Color scale		NO
K4:K16	Other Type	Color scale		NO
K4:K16	Other Type	Color scale		NO
K4:K16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Other Type	Color scale		NO
I4:I16	Cell Value	=1	text	NO
K4:K16	Other Type	Color scale		NO
K4:K16	Other Type	Color scale		NO
K4:K16	Other Type	Color scale		NO
K4:K16	Cell Value	=1	text	NO
M4:M16	Other Type	Color scale		NO
M4:M16	Other Type	Color scale		NO
M4:M16	Other Type	Color scale		NO
M4:M16	Cell Value	=1	text	NO
O4:O16	Other Type	Color scale		NO
O4:O16	Other Type	Color scale		NO
O4:O16	Other Type	Color scale		NO
O4:O16	Cell Value	=1	text	NO
Q4:Q16	Other Type	Color scale		NO
Q4:Q16	Other Type	Color scale		NO
Q4:Q16	Other Type	Color scale		NO
Q4:Q16	Cell Value	=1	text	NO
O26:O29	Other Type	Color scale		NO
O26:O29	Other Type	Color scale		NO
O26:O29	Other Type	Color scale		NO
O26:O29	Other Type	Color scale		NO
O26:O29	Other Type	Color scale		NO
O26:O29	Other Type	Color scale		NO
Q26:Q29	Other Type	Color scale		NO
Q26:Q29	Other Type	Color scale		NO
Q26:Q29	Other Type	Color scale		NO
Q26:Q29	Other Type	Color scale		NO
Q26:Q29	Other Type	Color scale		NO
Q26:Q29	Other Type	Color scale		NO
M26:M29	Other Type	Color scale		NO
M26:M29	Other Type	Color scale		NO
M26:M29	Other Type	Color scale		NO
M26:M29	Other Type	Color scale		NO
M26:M29	Other Type	Color scale		NO
M26:M29	Other Type	Color scale		NO
K26:K29	Other Type	Color scale		NO
K26:K29	Other Type	Color scale		NO
K26:K29	Other Type	Color scale		NO
K26:K29	Other Type	Color scale		NO
K26:K29	Other Type	Color scale		NO
K26:K29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Other Type	Color scale		NO
I26:I29	Cell Value	=1	text	NO
K26:K29	Other Type	Color scale		NO
K26:K29	Other Type	Color scale		NO
K26:K29	Other Type	Color scale		NO
K26:K29	Cell Value	=1	text	NO
M26:M29	Other Type	Color scale		NO
M26:M29	Other Type	Color scale		NO
M26:M29	Other Type	Color scale		NO
M26:M29	Cell Value	=1	text	NO
O26:O29	Other Type	Color scale		NO
O26:O29	Other Type	Color scale		NO
O26:O29	Other Type	Color scale		NO
O26:O29	Cell Value	=1	text	NO
Q26:Q29	Other Type	Color scale		NO
Q26:Q29	Other Type	Color scale		NO
Q26:Q29	Other Type	Color scale		NO
Q26:Q29	Cell Value	=1	text	NO
O19:O23	Other Type	Color scale		NO
O19:O23	Other Type	Color scale		NO
O19:O23	Other Type	Color scale		NO
O19:O23	Other Type	Color scale		NO
O19:O23	Other Type	Color scale		NO
O19:O23	Other Type	Color scale		NO
Q19:Q23	Other Type	Color scale		NO
Q19:Q23	Other Type	Color scale		NO
Q19:Q23	Other Type	Color scale		NO
Q19:Q23	Other Type	Color scale		NO
Q19:Q23	Other Type	Color scale		NO
Q19:Q23	Other Type	Color scale		NO
M19:M23	Other Type	Color scale		NO
M19:M23	Other Type	Color scale		NO
M19:M23	Other Type	Color scale		NO
M19:M23	Other Type	Color scale		NO
M19:M23	Other Type	Color scale		NO
M19:M23	Other Type	Color scale		NO
K19:K23	Other Type	Color scale		NO
K19:K23	Other Type	Color scale		NO
K19:K23	Other Type	Color scale		NO
K19:K23	Other Type	Color scale		NO
K19:K23	Other Type	Color scale		NO
K19:K23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Other Type	Color scale		NO
I19:I23	Cell Value	=1	text	NO
K19:K23	Other Type	Color scale		NO
K19:K23	Other Type	Color scale		NO
K19:K23	Other Type	Color scale		NO
K19:K23	Cell Value	=1	text	NO
M19:M23	Other Type	Color scale		NO
M19:M23	Other Type	Color scale		NO
M19:M23	Other Type	Color scale		NO
M19:M23	Cell Value	=1	text	NO
O19:O23	Other Type	Color scale		NO
O19:O23	Other Type	Color scale		NO
O19:O23	Other Type	Color scale		NO
O19:O23	Cell Value	=1	text	NO
Q19:Q23	Other Type	Color scale		NO
Q19:Q23	Other Type	Color scale		NO
Q19:Q23	Other Type	Color scale		NO
Q19:Q23	Cell Value	=1	text	NO
O32:O43	Other Type	Color scale		NO
O32:O43	Other Type	Color scale		NO
O32:O43	Other Type	Color scale		NO
O32:O43	Other Type	Color scale		NO
O32:O43	Other Type	Color scale		NO
O32:O43	Other Type	Color scale		NO
Q32:Q43	Other Type	Color scale		NO
Q32:Q43	Other Type	Color scale		NO
Q32:Q43	Other Type	Color scale		NO
Q32:Q43	Other Type	Color scale		NO
Q32:Q43	Other Type	Color scale		NO
Q32:Q43	Other Type	Color scale		NO
M32:M43	Other Type	Color scale		NO
M32:M43	Other Type	Color scale		NO
M32:M43	Other Type	Color scale		NO
M32:M43	Other Type	Color scale		NO
M32:M43	Other Type	Color scale		NO
M32:M43	Other Type	Color scale		NO
K32:K43	Other Type	Color scale		NO
K32:K43	Other Type	Color scale		NO
K32:K43	Other Type	Color scale		NO
K32:K43	Other Type	Color scale		NO
K32:K43	Other Type	Color scale		NO
K32:K43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Other Type	Color scale		NO
I32:I43	Cell Value	=1	text	NO
K32:K43	Other Type	Color scale		NO
K32:K43	Other Type	Color scale		NO
K32:K43	Other Type	Color scale		NO
K32:K43	Cell Value	=1	text	NO
M32:M43	Other Type	Color scale		NO
M32:M43	Other Type	Color scale		NO
M32:M43	Other Type	Color scale		NO
M32:M43	Cell Value	=1	text	NO
O32:O43	Other Type	Color scale		NO
O32:O43	Other Type	Color scale		NO
O32:O43	Other Type	Color scale		NO
O32:O43	Cell Value	=1	text	NO
Q32:Q43	Other Type	Color scale		NO
Q32:Q43	Other Type	Color scale		NO
Q32:Q43	Other Type	Color scale		NO
Q32:Q43	Cell Value	=1	text	NO
O30	Other Type	Color scale		NO
O30	Other Type	Color scale		NO
O30	Other Type	Color scale		NO
O30	Other Type	Color scale		NO
O30	Other Type	Color scale		NO
O30	Other Type	Color scale		NO
Q30	Other Type	Color scale		NO
Q30	Other Type	Color scale		NO
Q30	Other Type	Color scale		NO
Q30	Other Type	Color scale		NO
Q30	Other Type	Color scale		NO
Q30	Other Type	Color scale		NO
M30	Other Type	Color scale		NO
M30	Other Type	Color scale		NO
M30	Other Type	Color scale		NO
M30	Other Type	Color scale		NO
M30	Other Type	Color scale		NO
M30	Other Type	Color scale		NO
K30	Other Type	Color scale		NO
K30	Other Type	Color scale		NO
K30	Other Type	Color scale		NO
K30	Other Type	Color scale		NO
K30	Other Type	Color scale		NO
K30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Other Type	Color scale		NO
I30	Cell Value	=1	text	NO
K30	Other Type	Color scale		NO
K30	Other Type	Color scale		NO
K30	Other Type	Color scale		NO
K30	Cell Value	=1	text	NO
M30	Other Type	Color scale		NO
M30	Other Type	Color scale		NO
M30	Other Type	Color scale		NO
M30	Cell Value	=1	text	NO
O30	Other Type	Color scale		NO
O30	Other Type	Color scale		NO
O30	Other Type	Color scale		NO
O30	Cell Value	=1	text	NO
Q30	Other Type	Color scale		NO
Q30	Other Type	Color scale		NO
Q30	Other Type	Color scale		NO
Q30	Cell Value	=1	text	NO
O24	Other Type	Color scale		NO
O24	Other Type	Color scale		NO
O24	Other Type	Color scale		NO
O24	Other Type	Color scale		NO
O24	Other Type	Color scale		NO
O24	Other Type	Color scale		NO
Q24	Other Type	Color scale		NO
Q24	Other Type	Color scale		NO
Q24	Other Type	Color scale		NO
Q24	Other Type	Color scale		NO
Q24	Other Type	Color scale		NO
Q24	Other Type	Color scale		NO
M24	Other Type	Color scale		NO
M24	Other Type	Color scale		NO
M24	Other Type	Color scale		NO
M24	Other Type	Color scale		NO
M24	Other Type	Color scale		NO
M24	Other Type	Color scale		NO
K24	Other Type	Color scale		NO
K24	Other Type	Color scale		NO
K24	Other Type	Color scale		NO
K24	Other Type	Color scale		NO
K24	Other Type	Color scale		NO
K24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Other Type	Color scale		NO
I24	Cell Value	=1	text	NO
K24	Other Type	Color scale		NO
K24	Other Type	Color scale		NO
K24	Other Type	Color scale		NO
K24	Cell Value	=1	text	NO
M24	Other Type	Color scale		NO
M24	Other Type	Color scale		NO
M24	Other Type	Color scale		NO
M24	Cell Value	=1	text	NO
O24	Other Type	Color scale		NO
O24	Other Type	Color scale		NO
O24	Other Type	Color scale		NO
O24	Cell Value	=1	text	NO
Q24	Other Type	Color scale		NO
Q24	Other Type	Color scale		NO
Q24	Other Type	Color scale		NO
Q24	Cell Value	=1	text	NO
O17	Other Type	Color scale		NO
O17	Other Type	Color scale		NO
O17	Other Type	Color scale		NO
O17	Other Type	Color scale		NO
O17	Other Type	Color scale		NO
O17	Other Type	Color scale		NO
Q17	Other Type	Color scale		NO
Q17	Other Type	Color scale		NO
Q17	Other Type	Color scale		NO
Q17	Other Type	Color scale		NO
Q17	Other Type	Color scale		NO
Q17	Other Type	Color scale		NO
M17	Other Type	Color scale		NO
M17	Other Type	Color scale		NO
M17	Other Type	Color scale		NO
M17	Other Type	Color scale		NO
M17	Other Type	Color scale		NO
M17	Other Type	Color scale		NO
K17	Other Type	Color scale		NO
K17	Other Type	Color scale		NO
K17	Other Type	Color scale		NO
K17	Other Type	Color scale		NO
K17	Other Type	Color scale		NO
K17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Other Type	Color scale		NO
I17	Cell Value	=1	text	NO
K17	Other Type	Color scale		NO
K17	Other Type	Color scale		NO
K17	Other Type	Color scale		NO
K17	Cell Value	=1	text	NO
M17	Other Type	Color scale		NO
M17	Other Type	Color scale		NO
M17	Other Type	Color scale		NO
M17	Cell Value	=1	text	NO
O17	Other Type	Color scale		NO
O17	Other Type	Color scale		NO
O17	Other Type	Color scale		NO
O17	Cell Value	=1	text	NO
Q17	Other Type	Color scale		NO
Q17	Other Type	Color scale		NO
Q17	Other Type	Color scale		NO
Q17	Cell Value	=1	text	NO

 

[mumps]

copy the data from that row in Columns A,B,C & D to sheet 2

Do you not want column G copied as well?

copy the formatting that the data came from on sheet1

Currently, the Sheet1 you posted has no formatting such as cell and font color. Does your actual Sheet1 have any kind of formatting? If it does, please re-post it with the color formatting included.

Just to confirm: You want the code to be triggered after you enter the date in column B. Is this correct? If so, each time you make any changes in Sheet1 that you want copied to Sheet2, you will have to re-enter the date.