G
Guest
Hi all,
I have a spreadsheet that number of elements in Col A to Col D will
change (they have some # of items). e.g.
Row 1 is the header
Row 2 contain the descriptions.
Row 3 to whatever are the values.
Cell(E3).value = formula based on value in A3.. D3
Cell(E4).value = formula based on value in A4.. D4
How do I use VBA to copy the formula to the Col E based on number of items
in ColA?
Thanks.
I have a spreadsheet that number of elements in Col A to Col D will
change (they have some # of items). e.g.
Row 1 is the header
Row 2 contain the descriptions.
Row 3 to whatever are the values.
Cell(E3).value = formula based on value in A3.. D3
Cell(E4).value = formula based on value in A4.. D4
How do I use VBA to copy the formula to the Col E based on number of items
in ColA?
Thanks.