hi guys, I am new to VBA and I need help copying data from multiple worksheets to a single sheet in the same workbook.
my workbook has 12 worksheets named by their moths. each worksheet has a number of rows that gets updated. please note that some fields of "Importer" are blank. for each worksheet I need to copy all mass values less than 20 and paste them to a new sheet called "under20", and transfer the rest to "over20".
your help will be much appreciated
worksheet 1 : 2017-04
<tbody>
</tbody>
worksheet 12 : 2018-03
<tbody>
</tbody>
my workbook has 12 worksheets named by their moths. each worksheet has a number of rows that gets updated. please note that some fields of "Importer" are blank. for each worksheet I need to copy all mass values less than 20 and paste them to a new sheet called "under20", and transfer the rest to "over20".
your help will be much appreciated
worksheet 1 : 2017-04
Importer | Month | Origin | Mass | Price |
Importer 1 | April-17 | MZ | 100 | 90 |
Importer 2 | April-17 | ZM | 50 | 30 |
Importer 3 | April-17 | IN | 20 | 19 |
Importer 1 | April-17 | MZ | 200 | 150 |
April-17 | GB | 20 | 18 |
<tbody>
</tbody>
worksheet 12 : 2018-03
Importer | Month | Origin | Mass | Value |
Importer 1 | March -17 | MZ | 300 | 240 |
Importer 5 | March -17 | GB | 10 | 9 |
Importer 2 | March -17 | ZM | 60 | 50 |
March -17 | SY | 11 | 8 |
<tbody>
</tbody>