Please help me out. I want a vba that can automate this process that copy sheet2 to sheet1. For example on sheet2. Column D4 fruit column separate by a blank line with a new fruit with dates, purchase orders and quantity. There's six types of fruit that I need to keep track. What I want to do is to copy fruit types on column D all rows that are "apple" and copy data on column A,B and C and paste it to sheet1 on A9,B9 and C9 for Apple and D9,E9 and F9 for banana and so on. I'm sorry I'm trying to explain as best as I can.
Thank you very much.
A9 will always be apple
D9 will always be banana
G9 will always be grapes
example below
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 312px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody>
Thank you very much.
A9 will always be apple
D9 will always be banana
G9 will always be grapes
example below
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody> </tbody> |
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 312px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
4/28/2019 |
<tbody>
</tbody>