excelnovice128
New Member
- Joined
- Oct 29, 2018
- Messages
- 1
Hi all,
I'm a relative newbie to VBA, macros etc and am trying to learn a few things, was hoping you could help/guide me in the right direction. I am looking to create a macro which will copy data from one sheet and then sort into the correct sheets with the specified data. For example, i want to copy data from the below table into 2 separate sheets:
<tbody>
</tbody>
into:
<tbody>
</tbody>
Any help or push in the right direction would be much appreciated!!!
Thanks
I'm a relative newbie to VBA, macros etc and am trying to learn a few things, was hoping you could help/guide me in the right direction. I am looking to create a macro which will copy data from one sheet and then sort into the correct sheets with the specified data. For example, i want to copy data from the below table into 2 separate sheets:
Sales date | Fruit Sold | Colour | Quantity | Weight | Purchase Price | Sales Price |
01-Jan-18 | Apples | Red | 30 | 10 | 10 | 20 |
02-Jan-18 | Apples | Green | 5 | 15 | 10 | 20 |
02-Jan-18 | Oranges | Orange | 84 | 20 | 10 | 20 |
02-Jan-18 | Apples | Red | 11 | 10 | 10 | 20 |
01-Jan-18 | Oranges | Orange | 69 | 5 | 10 | 20 |
03-Jan-18 | Oranges | Orange | 17 | 5 | 10 | 20 |
01-Jan-18 | Oranges | Orange | 26 | 5 | 10 | 20 |
04-Jan-18 | Apples | Red | 23 | 10 | 10 | 20 |
03-Jan-18 | Apples | Red | 9 | 15 | 10 | 20 |
04-Jan-18 | Apples | Green | 65 | 20 | 10 | 20 |
01-Jan-18 | Apples | Green | 1 | 5 | 10 | 20 |
<tbody>
</tbody>
into:
Apples | |||
DATE | Quantity Sold | Purchase Price | Sales Price |
01-Jan | |||
02-Jan | |||
03-Jan | |||
04-Jan |
<tbody>
</tbody>
Any help or push in the right direction would be much appreciated!!!
Thanks