VBA - link sheet 1 and sheet 2 with autofill formula in sheet 2

[ACCA369]

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Source_Data	time_Stamp -1					Linked_data	Value_1	Value_2	Time_Stamp-2		Data_set2		Netural_set2
2	19	29/01/21 22:25:11					19	-90	90			5		26
3	10						10	-180	180			6		27
4	15						15	360	360			8		29
5	5						5	90	90			9		30
6	14						14	90	90			11
7	2						2	-90	90			12
8	34						34	-180	180			14
9	14						14	360	360			15
10	11						11	90	90			17
11	29						29	0	90			18
12	0						0	-90	90			20
13	15						15	180	180			21
14	13						13	-90	90			32
15	4						4	-180	180			33
16	27						27	0	360			35
17	25						25	-360	360			36
18	25						25	-720	720
19	27						27	0	1440
20	11						11	1440	1440
21	34	1)	Time stamp with seconds				34	-90	90
22	6	2)	source_data in sheet 1				6	180	180
23	30	3)	Linked_data In sheet 2				30	0	90
24	18		when data entered in sheet 1 - A column				18	90	90
25	1		G column in sheet 2 should be update automatically				1	-90	90
26	8						8	180	180
27	2	4)	sheet 2, H & I column contains formula				2	-90	90
28	24		H & I column should automatically update when				24	-180	180
29	18		data in G is entered				18	360	360
30	22						22	-90	90
31	27	5)	pls provide VBA code for Sheet 1 & Sheet 2				27	0	180
32	21		I am not familiar with VBA				21	180	180
33	34						34	-90	90
34	34						34	-180	180
35	22						22	-360	360
36	32						32	720	720
Sheet1

Cell Formulas
Range	Formula
B2	B2	=NOW()
G2:G36	G2	=A2
H2:H36	H2	=IF(ISNUMBER(MATCH(G2,Data_set2,0)),I2,IF(ISNUMBER(MATCH(G2,Netural_set2,0)),0,I2*-1))
I3:I36	I3	=IF(H2=0,I2,IF(H2<0,I2*2,90))

Named Ranges
Name	Refers To	Cells
Data_set2	=Sheet1!$L:$L	H2:H36
Netural_set2	=Sheet1!$N:$N	H2:H36

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A39	Expression	=OR(B2=0)	text	NO
A2:A39	Expression	=OR(B2>0)	text	NO
G1:G39	Expression	=OR(H1=0)	text	NO
G2:G39	Expression	=OR(H2>0)	text	NO

 

[Saurabhj]

Hi, you have shared Sheet1. Please confirm what is required?

What sheet2 contains?

Thanks,
Saurabh

 

[ACCA369]

Hi, you have shared Sheet1. Please confirm what is required?

What sheet2 contains?

Thanks,
Saurabh

Instead of sending two sheets , I have mentioned the contents of both sheet 2 and sheet 2 for quick understanding

Sheet 1 contains column A and B
Sheet 2 contains data Of column G, H, I, J, L & N

If you scroll right to column the attached excel doc. You can see the contents of sheet 2

 

[ACCA369]

Hi, you have shared Sheet1. Please confirm what is required?

What sheet2 contains?

Thanks,
Saurabh

Hi,

Using VBA Could you pls help me to
1) Sheet 1 A:A data need to be referenced in Sheet 2 in A:A range

2) whenever I entered data in Sheet 1 - A:A columns, the same data has to be get populated in Sheet 2 - A:A column

Sample ( Sheet1 - Column A:A).
10
20
15
0
34
36