Hi all,
Here is my post on excelforum: https://www.excelforum.com/excel-pr...riteria-and-vba-with-example.html#post5068295
I have explained it in much detail there, and there is an example workbook uploaded there as well.
I have 4 outcome tables (East, North, West and South) and I have 2 Data tables on Data1 sheet and on Data2 sheet.
I'm trying to copy the the data from tables on Data1 and Data2 to the Outcome tables, based on the "Crop Location", but Crop Location is not a column in either data table. Crop Name is in the Data tables and on the Admin sheet I have a Loc_Table that for each Crop Name has a Location beside it.
So it should be something like.. For Row(i) look up Location in sheet(Admin) Loc_Table, if it is East then copy Row(i) Column(Fruit Name) value, to Sheet(Outcome) EastTable first empty row Fruit Name column, and then the same for each column, because they are mixed up compared to each other so I can't just copy rows..
With VBA, as I will not be the one to create these tables in the future and I'd rather just have a button pressed and all the things generated than having to explain all the how to write which formula and manually copy paste, as its a risk of data loss.
Could someone help me with this please?
Here is my post on excelforum: https://www.excelforum.com/excel-pr...riteria-and-vba-with-example.html#post5068295
I have explained it in much detail there, and there is an example workbook uploaded there as well.
I have 4 outcome tables (East, North, West and South) and I have 2 Data tables on Data1 sheet and on Data2 sheet.
I'm trying to copy the the data from tables on Data1 and Data2 to the Outcome tables, based on the "Crop Location", but Crop Location is not a column in either data table. Crop Name is in the Data tables and on the Admin sheet I have a Loc_Table that for each Crop Name has a Location beside it.
So it should be something like.. For Row(i) look up Location in sheet(Admin) Loc_Table, if it is East then copy Row(i) Column(Fruit Name) value, to Sheet(Outcome) EastTable first empty row Fruit Name column, and then the same for each column, because they are mixed up compared to each other so I can't just copy rows..
With VBA, as I will not be the one to create these tables in the future and I'd rather just have a button pressed and all the things generated than having to explain all the how to write which formula and manually copy paste, as its a risk of data loss.
Could someone help me with this please?