Hi,
I`m a beginner to VBA and have the following requirement.Please provide your inputs
There are 2 worksheets, “Table” and “Object Size”
Worksheet “Table” has 2 tables in turn as follows;
Table1
<tbody>
</tbody>
Table2
<tbody>
</tbody>
Worksheet “Object Size” has 1 table
ObjectSizeTable
<tbody>
</tbody>
The requirement is as below:
If Table name in “Table1” is not equal to “Zero”, then itshould lookup for associated “Object Name” (listed in table 2 – the number ofobjects is not constant) in Table “ObjectSizeTable” of worksheet “Object Size”and then update the size in column 2 accordingly;
Say, new CO_ITEM size in ObjectSizeTable = 116 – (100-83.6) –This can be updated in the same cell or can be generated in a new cell of thesame worksheet.
Thanks,
Pankaj
I`m a beginner to VBA and have the following requirement.Please provide your inputs
There are 2 worksheets, “Table” and “Object Size”
Worksheet “Table” has 2 tables in turn as follows;
Table1
Table Name | Size |
COEP | 100 |
COST | 0 |
Table2
Object Name | COEP | COST |
CO_ITEM | 83.6 | 0 |
CO_ORDER | 10.2 | 0 |
SD_VBRK | 5.8 | 0 |
MM_EBAN | 0.4 | |
Worksheet “Object Size” has 1 table
ObjectSizeTable
Object Name | Size |
FI_DOC | 134.7 |
CO_ITEM | 116 |
MM_EBAN | 86 |
The requirement is as below:
If Table name in “Table1” is not equal to “Zero”, then itshould lookup for associated “Object Name” (listed in table 2 – the number ofobjects is not constant) in Table “ObjectSizeTable” of worksheet “Object Size”and then update the size in column 2 accordingly;
Say, new CO_ITEM size in ObjectSizeTable = 116 – (100-83.6) –This can be updated in the same cell or can be generated in a new cell of thesame worksheet.
Thanks,
Pankaj