Assumptions for this code:
1. Employee Inventory sheet has heading in row one so it will start checking the data in row 2.
2. Column Q does not have any empty cells.
3. EEs sheet will have headings in row one so the data will start copying in row 2.
Set I = Sheets("Employee Inventory")
Set e = Sheets("EEs")
Hi
I have a spreadsheet with the following headings:
A B C D E F
SKU SiteID HelperColumn Description May-16 ActualOrder
[TABLE="width: 766"]
[ATTACH=CONFIG]69185[/ATTACH]
[/td]
[/TABLE]
I need to copy information to another sheet based on the value in Column F(ActualOrder).
But I also need the vba to ONLY copy Columns (A)(D)(F) To the other sheet in the same workbook.
First sheet from where the data needs to be copied is: CheckAgainstSOH, and the sheet where the data needs to be copied too: Dashboard.
In Column F, you have values such as 50 etc, and "InsufficientSOH", I need the vba ONLY to copy the ones where there is ONLY a number value. And stop when Column F is blank. THis is so very important.
