Nicholas Agius
New Member
- Joined
- Apr 13, 2014
- Messages
- 9
Hello,
I am new to VBA in excel and i hope i can find some help here
Ok so before i start with the problem i have a macro which takes the results generated and puts them into a table and filters the data so that zeros does not show and arranges the table from largest to smallest.
Now i have a problem where i need to select the power, fuel oil consumption, weight and area from one table and the other power, fuel oil consumption, weight and area from the other table and combine them together so that i can have all possible combinations of the data, but i don't want the zeros to show in the combinations. frankly speaking i don't know where to even begin and i was hoping i can get some help. i need the combined data to show on a separate sheet.
The data of table 1 varies with rows as shown:
The Data of Table 2 varies with rows as shown:
I would like to achieve a result like this in the following columns and rows without having to input them manually:
If somebody can help me achieve this i would be very much grateful
I am new to VBA in excel and i hope i can find some help here
Ok so before i start with the problem i have a macro which takes the results generated and puts them into a table and filters the data so that zeros does not show and arranges the table from largest to smallest.
Now i have a problem where i need to select the power, fuel oil consumption, weight and area from one table and the other power, fuel oil consumption, weight and area from the other table and combine them together so that i can have all possible combinations of the data, but i don't want the zeros to show in the combinations. frankly speaking i don't know where to even begin and i was hoping i can get some help. i need the combined data to show on a separate sheet.
The data of table 1 varies with rows as shown:
The Data of Table 2 varies with rows as shown:
I would like to achieve a result like this in the following columns and rows without having to input them manually:
If somebody can help me achieve this i would be very much grateful