Copy Cell E value every n rows in A if (X-Y)<0 or (X-Z)<0

[Seb1991]

Hi guys, hope you're all fine. I need some help with the following macro
I'd like to copy a value of E2 in column A of the same row (A2) , if (L7-L22<0) or (L7-L33<0), in loop, so E2 in A2, from E2 every 45 rows so E47 in E47, E92 in A92 etc..
This macro should work as long as there is a value in E column (E2, E47, E92....)
I tried several times before asking here but i failed

Can you help me out with this ? Thank you so much for your time and your help!

 

[Seb1991]

On what line?

it doesn't say or i don't know where to see, it just pops up a window saying that, not underlining rows or part of the code

 

[kevin9999]

it doesn't say or i don't know where to see, it just pops up a window saying that, not underlining rows or part of the code

OK. When that box pops up, select Debug & one line will be highlighted in yellow. Which line?

 

[Seb1991]

It doesnt say, or maybe it's me i don't see it, but when the window pops up it just says the error, if i press on ? it says error 9, but i can't see underlined rows or codes

 

[Seb1991]

OK. When that box pops up, select Debug & one line will be highlighted in yellow. Which line?

Ok i did that but no line gets highlighted in yellow

 

[kevin9999]

OK. I'm afraid there's nothing more I can do unless I can get a copy of the actual sheet you're using. Options are:
A) post a copy of your actual sheet using the XL2BB - Excel Range to BBCode, (preferred) or
B) share a copy of your file via Dropbox, Google Drive or any similar file sharing site (you can easily disguise any sensitive information if needed)
Otherwise - I'm working blind

 

[kevin9999]

You could always go down the formula path...

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	HDR1	HDR2	HDR3	HDR4	HDR5	HDR6	HDR7	HDR8	HDR9	HDR10	HDR11	HDR12
2	Product Row 1				Product Row 1
3					Product Row 2
4					Product Row 3
5					Product Row 4
6					Product Row 5
7					Product Row 6							1
8					Product Row 7
9					Product Row 8
10					Product Row 9
11					Product Row 10
12
13
14
15
16
17
18
19
20
21	Product Row 20				Product Row 20
22					Product Row 21							2
23					Product Row 22
24					Product Row 23
25					Product Row 24
26					Product Row 25
27					Product Row 26
28					Product Row 27
29					Product Row 28
30					Product Row 29
31					Product Row 30
32	Product Row 31				Product Row 31
33					Product Row 32							2
34					Product Row 33
35					Product Row 34
36	Product Row 35				Product Row 35
37					Product Row 36
38					Product Row 37
39					Product Row 38
40					Product Row 39
41					Product Row 40
42					Product Row 41
43					Product Row 42
44					Product Row 43
45					Product Row 44
46					Product Row 45
47	Product Row 46				Product Row 46
48					Product Row 47
49					Product Row 48
50					Product Row 49
51					Product Row 50
52					Product Row 51							1
53					Product Row 52
54					Product Row 53
55					Product Row 54
56					Product Row 55
57
58
59
60
61
62
63
64
65
66
67												2
68
69
70
71
72
73
74
75					Product Row 74
76					Product Row 75
77	Product Row 76				Product Row 76
78					Product Row 77							2
79					Product Row 78
80					Product Row 79
81	Product Row 80				Product Row 80
82					Product Row 81
83					Product Row 82
84					Product Row 83
85					Product Row 84
86					Product Row 85
87					Product Row 86
88					Product Row 87
89					Product Row 88
90					Product Row 89
91					Product Row 90
92	Product Row 91				Product Row 91
93					Product Row 92
94					Product Row 93
95					Product Row 94
96					Product Row 95
97												1
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112												2
113
114
115
116
117
118
119
120
121
122
123												2
Sheet2

Cell Formulas
Range	Formula
A2:A96	A2	=IF(E2<>"",IF(OR(L7-L22<0,L7-L33<0),E2,""),"")

 

[Seb1991]

Here it is a piece of the file without the names (i think im not supposed to share this but anyway)

Test.xlsx

Shared with Dropbox

www.dropbox.com

 

[RudRud]

Hi, Would you mind to post your expected result for one example of E2?

 

[kevin9999]

Thank you for that. I suspect you didn't

Change the worksheet name to whatever you call it.

as advised in post #8. When I changed the sheet name to "Foglio1" - the code ran as I expected. I've shared the result on Google Drive - see if it's giving the expected result.
seb1991.xlsm

 

[Seb1991]

Thank you for that. I suspect you didn't

as advised in post #8. When I changed the sheet name to "Foglio1" - the code ran as I expected. I've shared the result on Google Drive - see if it's giving the expected result.
seb1991.xlsm

I did change at first but it kept popping up the same error, so i guessed it was in english. But the result is different, a lot of values i don't need get copied in column A, i only need the value in column E2, E47, E92 etc, which is the product code.
In this case, E2 should not be copied because E7 (272) - E22 (0 because is empty) is >0 , i need to copy E7 in A7 only when is <0 , same as E7-E33 .