Hi all,
I don't have much knowledge of VBA but am using research and help I can get from the web to create a tool. I am stuck at a stage and was wondering if anyone could help me.
I have the following in sheet 1:
<tbody>
</tbody>
What this sheet does is when type in the supplier name, most of the other data gets populated. However, once that is done, I want to be able to archive this data into sheet2 every single time I use it using a macro in such a way that it only copies non blank cells and paste it after populated cells in sheet2. I have tried a code which I found on the web that does paste from sheet1 to sheet2 but leaves a huge gap between the old and freshly pasted data.
I would be very grateful if anyone can help me.
Thanks a lot
KSAExcel
I don't have much knowledge of VBA but am using research and help I can get from the web to create a tool. I am stuck at a stage and was wondering if anyone could help me.
I have the following in sheet 1:
SKU NUMBER | Supplier | ISSUE | RECEIPT DATE | QUANTITY | PURGE NUMBER | ORDER NUMBER | CFC ACTION (RECEIPT OR RETURN) |
<tbody>
</tbody>
What this sheet does is when type in the supplier name, most of the other data gets populated. However, once that is done, I want to be able to archive this data into sheet2 every single time I use it using a macro in such a way that it only copies non blank cells and paste it after populated cells in sheet2. I have tried a code which I found on the web that does paste from sheet1 to sheet2 but leaves a huge gap between the old and freshly pasted data.
I would be very grateful if anyone can help me.
Thanks a lot
KSAExcel