Chanzuihou
New Member
- Joined
- Jul 28, 2016
- Messages
- 19
Dear all,
I am very entry-level with VBA and am now desperately needing a set of VBA, for one of my repeating work task. Is possible that any of you VBA expert please help me with a set of VBA code please? Any help is sincerely appreciated.
In the below raw data, would like to move the following data across to Sheet "DATA_AF_VBA" (pls refer to below screen paste, the desired format). Data I would like to copy across is:
- Webshop
- Price
- Product
Really appreciate any advice. thanks heaps ~~~~
Raw data:
Desired format: using VBA to move raw data into the desired format:
I am very entry-level with VBA and am now desperately needing a set of VBA, for one of my repeating work task. Is possible that any of you VBA expert please help me with a set of VBA code please? Any help is sincerely appreciated.
In the below raw data, would like to move the following data across to Sheet "DATA_AF_VBA" (pls refer to below screen paste, the desired format). Data I would like to copy across is:
- Webshop
- Price
- Product
Really appreciate any advice. thanks heaps ~~~~
Raw data:
Excel 2012 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Price2Spy Tool - Daily notification e-mail | |||||||||
2 | Price2Spy has detected price changes. Please see the list of the products below. | |||||||||
3 | Product : CFX40W | |||||||||
4 | Webshop | Price | Available | Last checked | Last change | Failed attempts | Last message error | |||
5 | 12 Volt Technology | 1,039.00 AUD | ||||||||
6 | was: 1,079.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/04/2019 0:00 | 0 | ||||
7 | seabreeze | 1,099.00 AUD | ||||||||
8 | was: 973.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/04/2006 19:40 | 0 | ||||
9 | Tentworld | 1,099.99 AUD | ||||||||
10 | was: 973.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/04/2004 20:57 | 0 | ||||
11 | Snowys | 1,149.00 AUD | ||||||||
12 | was: 1,039.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/03/2008 15:41 | 0 | ||||
13 | Anacondastores | 1,149.00 AUD | ||||||||
14 | was: 1,039.20 AUD | ? 10.57 % | Yes | 1/04/2020 2:14 | 1/04/2020 2:14 | 0 | ||||
15 | My Generator | 1,249.00 AUD | ||||||||
16 | was: 1,079.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/04/2019 0:00 | 0 | ||||
17 | BCF | 1,299.00 AUD | Yes | 1/04/2020 2:14 | 1/03/2007 15:14 | 0 | ||||
18 | Product : CFX50W | |||||||||
19 | Webshop | Price | Available | Last checked | Last change | Failed attempts | Last message error | |||
20 | 12 Volt Technology | 1,159.00 AUD | ||||||||
21 | was: 1,198.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/04/2019 0:19 | 0 | ||||
22 | Tentworld | 1,199.00 AUD | ||||||||
23 | was: 1,085.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/04/2004 20:18 | 0 | ||||
24 | seabreeze | 1,199.00 AUD | ||||||||
25 | was: 1,085.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/04/2006 19:41 | 0 | ||||
26 | Snowys | 1,249.00 AUD | ||||||||
27 | was: 1,159.00 AUD | ? | Yes | 1/04/2020 2:14 | 1/03/2008 15:36 | 0 | ||||
28 | Anacondastores | 1,299.00 AUD | ||||||||
29 | was: 1,159.20 AUD | ? 12.06 % | Yes | 1/04/2020 2:14 | 1/04/2020 2:14 | 0 | ||||
30 | BCF | 1,449.00 AUD | Yes | 1/04/2020 2:14 | 1/03/2007 15:23 | 0 | ||||
31 | Rays Outdoors | 1,449.00 AUD | Yes | 1/04/2020 2:14 | 1/03/2007 15:23 | 0 | ||||
32 | Product : CFX65W | |||||||||
33 | Webshop | Price | Available | Last checked | Last change | Failed attempts | Last message error | |||
34 | 12 Volt Technology | 1,279.00 AUD | ||||||||
35 | was: 1,399.00 AUD | ? | Yes | 1/04/2020 1:27 | 1/04/2019 0:19 | 0 | ||||
36 | Tentworld | 1,399.99 AUD | ||||||||
37 | was: 1,198.00 AUD | ? | Yes | 1/04/2020 1:27 | 1/04/2004 20:39 | 0 | ||||
38 | Snowys | 1,449.00 AUD | ||||||||
39 | was: 1,279.00 AUD | ? | Yes | 1/04/2020 1:27 | 1/03/2008 15:59 | 1 | There's been a problem while loading a page. | |||
40 | Anacondastores | 1,449.00 AUD | ||||||||
41 | was: 1,279.20 AUD | ? 13.27 % | Yes | 1/04/2020 1:27 | 1/04/2020 1:27 | 0 | ||||
42 | BCF | 1,599.00 AUD | Yes | 1/04/2020 1:27 | 1/03/2007 15:30 | 0 | ||||
43 | My Generator | 1,599.00 AUD | ||||||||
44 | was: 1,299.00 AUD | ? | Yes | 1/04/2020 1:27 | 1/04/2019 0:19 | 0 | ||||
45 | Product : CFX95DZW | |||||||||
46 | Webshop | Price | Available | Last checked | Last change | Failed attempts | Last message error | |||
47 | 12 Volt Technology | 1,519.00 AUD | ||||||||
48 | was: 1,699.00 AUD | ? | Yes | 1/04/2020 2:04 | 1/04/2019 0:00 | 0 | ||||
49 | Tentworld | 1,699.00 AUD | ||||||||
50 | was: 1,423.00 AUD | ? | Yes | 1/04/2020 2:04 | 1/04/2004 20:18 | 0 | ||||
51 | Snowys | 1,749.00 AUD | ||||||||
52 | was: 1,599.00 AUD | ? | Yes | 1/04/2020 2:04 | 1/03/2008 15:45 | 0 | ||||
53 | Anacondastores | 1,749.00 AUD | ||||||||
54 | was: 1,519.20 AUD | ? 15.13 % | Yes | 1/04/2020 2:04 | 1/04/2020 2:04 | 0 | ||||
55 | BCF | 1,899.00 AUD | Yes | 1/04/2020 2:04 | 1/03/2007 15:35 | 0 | ||||
56 | Rays Outdoors | 1,899.00 AUD | Yes | 1/04/2020 2:04 | 1/03/2007 15:37 | 0 | ||||
57 | My Generator | 1,899.00 AUD | ||||||||
58 | was: 1,649.00 AUD | ? | Yes | 1/04/2020 2:04 | 1/04/2019 0:00 | 0 | ||||
59 | seabreeze | 1,569.00 AUD | ||||||||
60 | was: 1,749.00 AUD | ? | Yes | 1/03/2025 20:00 | 1/03/2014 16:13 | 10 | This Webshop is supported, but the URL you've entered is not a single product page. | |||
0419 |
Desired format: using VBA to move raw data into the desired format:
Excel 2012 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | Webshop | Price | Product | Date | ||
2 | 12 Volt Technology | 1,039.00 | CFX40W | 19/04/2017 | ||
3 | seabreeze | 1,099.00 | CFX40W | 19/04/2017 | ||
4 | Tentworld | 1,099.99 | CFX40W | 19/04/2017 | ||
5 | Snowys | 1,149.00 | CFX40W | 19/04/2017 | ||
6 | Anacondastores | 1,149.00 | CFX40W | 19/04/2017 | ||
7 | My Generator | 1,249.00 | CFX40W | 19/04/2017 | ||
8 | BCF | 1,299.00 | CFX40W | 19/04/2017 | ||
9 | 12 Volt Technology | 1,159.00 | CFX50W | 19/04/2017 | ||
10 | Tentworld | 1,199.00 | CFX50W | 19/04/2017 | ||
11 | seabreeze | 1,199.00 | CFX50W | 19/04/2017 | ||
12 | Snowys | 1,249.00 | CFX50W | 19/04/2017 | ||
13 | Anacondastores | 1,299.00 | CFX50W | 19/04/2017 | ||
14 | BCF | 1,449.00 | CFX50W | 19/04/2017 | ||
15 | Rays Outdoors | 1,449.00 | CFX50W | 19/04/2017 | ||
16 | 12 Volt Technology | 1,279.00 | CFX65W | 19/04/2017 | ||
17 | Tentworld | 1,399.99 | CFX65W | 19/04/2017 | ||
18 | Snowys | 1,449.00 | CFX65W | 19/04/2017 | ||
19 | Anacondastores | 1,449.00 | CFX65W | 19/04/2017 | ||
20 | BCF | 1,599.00 | CFX65W | 19/04/2017 | ||
21 | My Generator | 1,599.00 | CFX65W | 19/04/2017 | ||
22 | 12 Volt Technology | 1,519.00 | CFX95DZW | 19/04/2017 | ||
23 | Tentworld | 1,699.00 | CFX95DZW | 19/04/2017 | ||
24 | Snowys | 1,749.00 | CFX95DZW | 19/04/2017 | ||
25 | Anacondastores | 1,749.00 | CFX95DZW | 19/04/2017 | ||
26 | BCF | 1,899.00 | CFX95DZW | 19/04/2017 | ||
27 | Rays Outdoors | 1,899.00 | CFX95DZW | 19/04/2017 | ||
28 | My Generator | 1,899.00 | CFX95DZW | 19/04/2017 | ||
29 | seabreeze | 1,569.00 | CFX95DZW | 19/04/2017 | ||
Data_AF_VBA |