import txt with condition

cgpa

New Member
Joined
Jan 23, 2023
Messages
11
Office Version
  1. 2007
Platform
  1. Windows
hello guys,
Does anyone know how to import csv(text) file with condition with VBA? for example I want to import a file and I need it to import only the content (lines) that contains the word "cheese", as if it were a filter.
this txt file changes the quantity every day, so sometimes there are 1000 thousand products, other times 12000, the quantity of products varies

16​
65​
18400​
19/05/2023​
15​
fruitBANANADC
41,55​
18400​
32400​
87000​
137800​
10​
53​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
66​
42200​
19/05/2023​
15​
fruitBANANADC
41,8​
42200​
101600​
112200​
256000​
21​
74​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
67​
56700​
19/05/2023​
15​
fruitBANANADC
41,3​
56700​
483200​
383400​
923300​
22​
94​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
68​
21700​
19/05/2023​
16​
drinkrefrigeratorDC
42,3​
21700​
659900​
53300​
734900​
16​
86​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
69​
52900​
19/05/2023​
16​
drinkrefrigeratorDC
40,8​
52900​
414700​
30500​
498100​
18​
81​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
70​
120700​
19/05/2023​
16​
drinkrefrigeratorDC
42,05​
120700​
88800​
107700​
317200​
13​
123​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
71​
96100​
19/05/2023​
16​
drinkrefrigeratorDC
42,8​
96100​
3274200​
3674200​
7044500​
33​
123​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
72​
33500​
19/05/2023​
16​
drinkrefrigeratorDC
42,55​
33500​
111100​
29000​
173600​
20​
63​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
73​
69800​
19/05/2023​
16​
drinkrefrigeratorDC
43,3​
69800​
5977800​
387500​
6435100​
38​
158​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
74​
104100​
19/05/2023​
16​
drinkrefrigeratorDC
43,05​
104100​
46700​
686500​
837300​
36​
176​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
75​
63400​
19/05/2023​
16​
drinkrefrigeratorDC
44,55​
63400​
289500​
126400​
479300​
26​
94​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
76​
48400​
19/05/2023​
16​
drinkrefrigeratorDC
43,55​
48400​
394800​
98600​
541800​
30​
117​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
77​
68700​
19/05/2023​
16​
drinkrefrigeratorDC
44,3​
68700​
896000​
81800​
1046500​
105​
158​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
78​
121300​
19/05/2023​
16​
drinkrefrigeratorDC
44,05​
121300​
1671700​
8736100​
10529100​
59​
195​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
79​
58600​
19/05/2023​
16​
drinkrefrigeratorDC
44,8​
58600​
2707800​
459200​
3225600​
106​
158​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
80​
159200​
19/05/2023​
16​
drinkrefrigeratorDC
45,55​
159200​
1065500​
296100​
1520800​
74​
152​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
81​
228200​
19/05/2023​
16​
drinkrefrigeratorDC
45,3​
228200​
1671400​
1664300​
3563900​
135​
206​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
82​
247200​
19/05/2023​
16​
drinkrefrigeratorDC
43,8​
247200​
730000​
176800​
1154000​
56​
109​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
83​
86600​
19/05/2023​
16​
drinkrefrigeratorDC
46,55​
86600​
146400​
551500​
784500​
28​
101​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
84​
76400​
19/05/2023​
16​
drinkrefrigeratorDC
46,3​
76400​
153400​
707300​
937100​
46​
108​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
134​
25100​
16/06/2023​
16​
drinkrefrigeratorDC
40,29​
25100​
9100​
23000​
57200​
8​
42​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
135​
40900​
16/06/2023​
16​
drinkrefrigeratorDC
39,29​
40900​
7800​
107600​
156300​
9​
46​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
136​
46500​
16/06/2023​
16​
drinkrefrigeratorDC
37,54​
46500​
2200​
31100​
79800​
8​
45​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
137​
14100​
16/06/2023​
17​
cheesemozzarelaDC
40,79​
14100​
23000​
56800​
93900​
10​
57​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
138​
71100​
16/06/2023​
17​
cheesemozzarelaDC
38,04​
71100​
186100​
119800​
377000​
11​
92​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
139​
24200​
16/06/2023​
17​
cheesemozzarelaDC
41,29​
24200​
2919200​
62800​
3006200​
16​
79​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
140​
16400​
16/06/2023​
17​
cheesemozzarelaDC
38,54​
16400​
200​
139400​
156000​
8​
46​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
141​
23500​
16/06/2023​
17​
cheesemozzarelaDC
41,79​
23500​
242300​
32000​
297800​
15​
64​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
142​
71400​
16/06/2023​
17​
cheesemozzarelaDC
39,04​
71400​
7100​
155400​
233900​
12​
99​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
143​
38600​
16/06/2023​
17​
cheesemozzarelaDC
42,29​
38600​
304300​
74000​
416900​
17​
79​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
144​
63500​
16/06/2023​
17​
cheesemozzarelaDC
39,54​
63500​
100​
144900​
208500​
10​
91​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
145​
73800​
16/06/2023​
17​
cheesemozzarelaDC
42,79​
73800​
345000​
314200​
733000​
37​
113​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
146​
200100​
16/06/2023​
17​
cheesemozzarelaDC
40,04​
200100​
13700​
177500​
391300​
19​
200​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
147​
70000​
16/06/2023​
17​
cheesemozzarelaDC
43,29​
70000​
251700​
120500​
442200​
56​
160​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
148​
44700​
16/06/2023​
17​
cheesemozzarelaDC
40,54​
44700​
10300​
181400​
236400​
8​
78​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
149​
53400​
16/06/2023​
17​
cheesemozzarelaDC
43,79​
53400​
276000​
1462300​
1791700​
131​
111​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
150​
60200​
16/06/2023​
17​
cheesemozzarelaDC
41,04​
60200​
476500​
144900​
681600​
14​
111​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
151​
58400​
16/06/2023​
17​
cheesemozzarelaDC
44,29​
58400​
397300​
227400​
683100​
147​
123​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
152​
23900​
16/06/2023​
17​
cheesemozzarelaDC
41,54​
23900​
102800​
86600​
213300​
7​
70​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
153​
83000​
16/06/2023​
17​
cheesemozzarelaDC
44,79​
83000​
21100​
98400​
202500​
38​
64​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
154​
58800​
16/06/2023​
17​
cheesemozzarelaDC
42,04​
58800​
35600​
194300​
288700​
14​
159​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
155​
22000​
16/06/2023​
17​
cheesemozzarelaDC
44,89​
22000​
72400​
217600​
312000​
44​
46​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
156​
37600​
16/06/2023​
17​
cheesemozzarelaDC
45,29​
37600​
1796700​
736500​
2570800​
107​
130​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
157​
14000​
16/06/2023​
17​
cheesemozzarelaDC
49,79​
14000​
125300​
305700​
445000​
37​
40​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
158​
48700​
16/06/2023​
17​
cheesemozzarelaDC
42,54​
48700​
261500​
56100​
366300​
22​
73​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
159​
37800​
16/06/2023​
19​
cheeseparmesanDC
45,79​
37800​
461400​
257400​
756600​
50​
78​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
160​
9100​
16/06/2023​
19​
cheeseparmesanDC
53,79​
9100​
0​
514400​
523500​
32​
12​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
161​
106300​
16/06/2023​
19​
cheeseparmesanDC
43,04​
106300​
35800​
381200​
523300​
29​
185​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
162​
55300​
16/06/2023​
19​
cheeseparmesanDC
46,29​
55300​
356200​
183400​
594900​
48​
107​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
163​
35200​
16/06/2023​
19​
cheeseparmesanDC
43,54​
35200​
256000​
99000​
390200​
25​
115​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
164​
28200​
16/06/2023​
19​
cheeseparmesanDC
46,79​
28200​
173800​
347000​
549000​
39​
91​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
165​
113000​
16/06/2023​
19​
cheeseparmesanDC
44,04​
113000​
68700​
123100​
304800​
54​
184​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
166​
28300​
16/06/2023​
19​
cheeseparmesanDC
47,29​
28300​
264300​
1068700​
1361300​
63​
96​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
167​
58200​
16/06/2023​
19​
cheeseparmesanDC
44,54​
58200​
196100​
46200​
300500​
32​
94​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
168​
4600​
16/06/2023​
19​
cheeseparmesanDC
47,79​
4600​
305700​
291000​
601300​
37​
45​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
169​
147200​
16/06/2023​
19​
cheeseparmesanDC
45,04​
147200​
206200​
10423600​
10777000​
318​
175​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
170​
23700​
16/06/2023​
19​
cheeseparmesanDC
48,29​
23700​
470200​
118200​
612100​
37​
66​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
171​
41900​
16/06/2023​
19​
cheeseparmesanDC
45,54​
41900​
283700​
178200​
503800​
47​
92​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
172​
1800​
16/06/2023​
19​
cheeseparmesanDC
48,79​
1800​
1800​
670000​
673600​
15​
23​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
173​
53400​
16/06/2023​
19​
cheeseparmesanDC
46,04​
53400​
693400​
378100​
1124900​
54​
169​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
174​
22800​
16/06/2023​
19​
cheeseparmesanDC
49,04​
22800​
52700​
1370500​
1446000​
26​
53​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
175​
142500​
16/06/2023​
19​
cheeseparmesanDC
49,29​
142500​
30100​
920500​
1093100​
19​
51​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
176​
5400​
16/06/2023​
19​
cheeseparmesanDC
54,79​
5400​
100500​
73500​
179400​
16​
15​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
177​
0​
21/07/2023​
19​
cheeseparmesanDC
32,86​
0​
0​
400​
400​
1​
1​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
178​
0​
21/07/2023​
19​
cheeseparmesanDC
33,11​
0​
0​
8300​
8300​
1​
3​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
179​
0​
21/07/2023​
19​
cheeseparmesanDC
33,86​
0​
600​
0​
600​
1​
2​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
180​
0​
21/07/2023​
19​
cheeseparmesanDC
34,11​
0​
200​
700​
900​
1​
3​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
181​
400​
21/07/2023​
19​
cheeseparmesanDC
34,36​
400​
1200​
40200​
41800​
2​
5​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
182​
22200​
21/07/2023​
19​
cheeseparmesanDC
35,11​
22200​
0​
7400​
29600​
2​
7​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
183​
1500​
21/07/2023​
19​
cheeseparmesanDC
35,36​
1500​
0​
0​
1500​
1​
1​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
184​
0​
21/07/2023​
19​
cheeseparmesanDC
35,61​
0​
0​
18300​
18300​
2​
5​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
185​
2200​
21/07/2023​
19​
cheeseparmesanDC
36,11​
2200​
0​
6900​
9100​
1​
9​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
186​
19000​
21/07/2023​
19​
cheeseparmesanDC
36,61​
19000​
100​
3700​
22800​
2​
10​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
187​
6800​
21/07/2023​
19​
cheeseparmesanDC
37,61​
6800​
0​
200​
7000​
1​
4​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
188​
11500​
21/07/2023​
19​
cheeseparmesanDC
37,11​
11500​
0​
400​
11900​
1​
4​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
189​
22200​
21/07/2023​
19​
cheeseparmesanDC
37,36​
22200​
1500​
25800​
49500​
3​
21​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
190​
0​
21/07/2023​
19​
cheeseparmesanDC
38,86​
0​
900​
1400​
2300​
1​
4​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
191​
2700​
21/07/2023​
19​
cheeseparmesanDC
38,11​
2700​
0​
8500​
11200​
2​
10​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
192​
700​
21/07/2023​
19​
cheeseparmesanDC
38,36​
700​
2000​
5400​
8100​
1​
15​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
193​
0​
21/07/2023​
19​
cheeseparmesanDC
37,86​
0​
2300​
10300​
12600​
3​
5​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
194​
5800​
21/07/2023​
19​
cheeseparmesanDC
39,61​
5800​
1300​
25700​
32800​
2​
18​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
195​
22500​
21/07/2023​
19​
cheeseparmesanDC
40,11​
22500​
0​
34800​
57300​
2​
41​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
196​
16300​
21/07/2023​
19​
cheeseparmesanDC
39,11​
16300​
19900​
21500​
57700​
2​
17​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
197​
9200​
21/07/2023​
19​
cheeseparmesanDC
39,36​
9200​
200​
5300​
14700​
4​
10​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
198​
5900​
21/07/2023​
19​
cheeseparmesanDC
40,61​
5900​
0​
10900​
16800​
3​
11​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
199​
5200​
21/07/2023​
19​
cheeseparmesanDC
41,11​
5200​
6300​
25000​
36500​
2​
35​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
200​
21600​
21/07/2023​
19​
cheeseparmesanDC
41,36​
21600​
300​
9100​
31000​
2​
12​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
201​
71400​
21/07/2023​
19​
cheeseparmesanDC
41,61​
71400​
0​
14800​
86200​
2​
14​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
202​
500​
21/07/2023​
19​
cheeseparmesanDC
41,86​
500​
0​
48500​
49000​
3​
9​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
203​
195300​
21/07/2023​
19​
cheeseparmesanDC
39,86​
195300​
5500​
120800​
321600​
5​
14​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
204​
8600​
21/07/2023​
19​
cheeseparmesanDC
42,36​
8600​
19700​
16800​
45100​
5​
22​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
205​
39400​
21/07/2023​
19​
cheeseparmesanDC
42,11​
39400​
1300​
10800​
51500​
5​
16​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
206​
3400​
21/07/2023​
19​
cheeseparmesanDC
42,61​
3400​
0​
7600​
11000​
2​
7​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
207​
60100​
21/07/2023​
19​
cheeseparmesanDC
43,11​
60100​
1800​
131200​
193100​
14​
60​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
208​
4100​
21/07/2023​
19​
cheeseparmesanDC
43,36​
4100​
177200​
18900​
200200​
7​
32​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
209​
69000​
21/07/2023​
19​
cheeseparmesanDC
43,61​
69000​
0​
108800​
177800​
7​
27​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
210​
44900​
21/07/2023​
19​
cheeseparmesanDC
43,86​
44900​
28400​
50000​
123300​
11​
38​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
211​
23900​
21/07/2023​
19​
cheeseparmesanDC
42,86​
23900​
0​
14600​
38500​
7​
19​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
212​
6500​
21/07/2023​
19​
cheeseparmesanDC
44,36​
6500​
30300​
33500​
70300​
10​
35​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
213​
35400​
21/07/2023​
19​
cheeseparmesanDC
44,11​
35400​
500​
264700​
300600​
10​
70​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
214​
26400​
21/07/2023​
19​
cheeseparmesanDC
44,61​
26400​
0​
34000​
60400​
5​
27​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
215​
5500​
21/07/2023​
19​
cheeseparmesanDC
44,86​
5500​
66300​
23100​
94900​
11​
21​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
216​
85100​
21/07/2023​
19​
cheeseparmesanDC
45,11​
85100​
8000​
59900​
153000​
10​
59​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
217​
11600​
21/07/2023​
19​
cheeseparmesanDC
45,36​
11600​
94800​
46700​
153100​
10​
25​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
218​
2500​
21/07/2023​
19​
cheeseparmesanDC
45,61​
2500​
38000​
25600​
66100​
5​
19​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
219​
21100​
21/07/2023​
19​
cheeseparmesanDC
46,11​
21100​
339900​
38300​
399300​
7​
53​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
220​
3100​
21/07/2023​
19​
cheeseparmesanDC
46,36​
3100​
500​
13400​
17000​
7​
18​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
221​
2300​
21/07/2023​
19​
cheeseparmesanDC
46,86​
2300​
142000​
7100​
151400​
4​
11​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
19​
222​
11300​
21/07/2023​
19​
cheeseparmesanDC
45,86​
11300​
51000​
12300​
74600​
9​
22​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
223​
3400​
21/07/2023​
19​
cheeseparmesanDC
47,86​
3400​
0​
5700​
9100​
6​
15​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
241​
0​
21/07/2023​
18​
cheeseparmesanDC
60,61​
0​
0​
100​
100​
1​
1​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
242​
0​
21/07/2023​
18​
cheeseparmesanDC
61,61​
0​
0​
5200​
5200​
4​
1​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
243​
2600​
18/08/2023​
18​
cheeseparmesanDC
39,55​
2600​
0​
4000​
6600​
2​
5​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
244​
3500​
18/08/2023​
18​
cheeseparmesanDC
41,05​
3500​
0​
4800​
8300​
3​
10​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
245​
4500​
18/08/2023​
18​
cheeseparmesanDC
42,3​
4500​
0​
4000​
8500​
2​
2​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
246​
4200​
18/08/2023​
18​
cheeseparmesanDC
43,3​
4200​
0​
27200​
31400​
3​
8​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
247​
3300​
18/08/2023​
18​
cheeseparmesanDC
44,05​
3300​
0​
10400​
13700​
3​
8​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
248​
18200​
16/08/2024​
18​
cheeseparmesanDC
42,04​
18200​
0​
374400​
392600​
18​
48​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
249​
8600​
18/08/2023​
18​
cheeseparmesanDC
45,05​
8600​
0​
22500​
31100​
3​
22​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
250​
10100​
18/08/2023​
18​
cheeseparmesanDC
47,55​
10100​
0​
12800​
22900​
2​
5​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
251​
800​
15/09/2023​
18​
cheeseparmesanDC
33,82​
800​
0​
200​
1000​
5​
4​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
252​
25000​
15/09/2023​
18​
cheeseparmesanDC
43,82​
25000​
0​
1000​
26000​
3​
2​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
253​
2500​
15/09/2023​
18​
cheeseparmesanDC
44,07​
2500​
0​
1700​
4200​
2​
2​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
254​
5300​
15/09/2023​
18​
cheeseparmesanDC
38,82​
5300​
23900​
22200​
51400​
5​
15​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
255​
4000​
15/09/2023​
18​
cheeseGorgonzolaDC
45,07​
4000​
0​
500​
4500​
2​
2​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
15​
256​
110900​
15/09/2023​
18​
cheeseGorgonzolaDC
45,32​
110900​
500​
0​
111400​
3​
5​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
257​
3100​
15/09/2023​
18​
cheeseGorgonzolaDC
47,07​
3100​
0​
5700​
8800​
2​
7​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
258​
75600​
15/09/2023​
18​
cheeseGorgonzolaDC
48,07​
75600​
0​
300​
75900​
2​
6​
85​
20​
AA
03/04/2023​
43,16​
9,3E+08​
58856​
21607700​
16​
979​
4600​
16/06/2023​
18​
cheeseGorgonzolaDC
18,72​
4600​
85800​
155600​
246000​
8​
32​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
15​
980​
69100​
16/06/2023​
18​
cheeseGorgonzolaDC
18,47​
69100​
195200​
38500​
302800​
7​
28​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
15​
981​
47600​
16/06/2023​
18​
cheeseGorgonzolaDC
19,47​
47600​
172900​
21300​
241800​
9​
36​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
16​
982​
28800​
16/06/2023​
18​
cheeseGorgonzolaDC
19,72​
28800​
697800​
121400​
848000​
6​
50​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
16​
983​
21700​
16/06/2023​
18​
cheeseGorgonzolaDC
18,22​
21700​
125600​
129400​
276700​
5​
54​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
16​
984​
73600​
16/06/2023​
18​
cheeseGorgonzolaDC
17,72​
73600​
81100​
240700​
395400​
5​
32​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
16​
985​
1375700​
16/06/2023​
18​
cheeseGorgonzolaDC
23,72​
1375700​
550800​
2321100​
4247600​
34​
318​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
15​
986​
50600​
16/06/2023​
21​
cheeseGorgonzolaDC
20,47​
50600​
293300​
128000​
471900​
24​
85​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
16​
987​
51700​
16/06/2023​
21​
cheeseGorgonzolaDC
19,22​
51700​
338200​
479900​
869800​
13​
96​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
16​
988​
91700​
16/06/2023​
21​
cheeseGorgonzolaDC
21,72​
91700​
1081600​
788200​
1961500​
28​
193​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
16​
989​
190500​
16/06/2023​
21​
coldhamDC
22,72​
190500​
1326100​
747600​
2264200​
33​
309​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
16​
990​
5900​
16/06/2023​
21​
coldhamDC
30,22​
5900​
568900​
38800​
613600​
31​
24​
85​
20​
AA
03/04/2023​
29,2​
9,27E+08​
30180​
31615500​
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Seems to me that an easy way would be to just import the whole file, and then use filters afterwards to get/delete the data that you want.

That can all be automated, and a lot of the VBA code you can get using the Macro Recorder.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,177
Members
453,021
Latest member
Justyna P

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