ranuse
10-24-2010, 01:49 PM
Hi,
I'm trying to write some code that will do the following:
1. Select the last column that contains data in a worksheet
2. Inserts a blank column to the left of the selected column
3. Enter specified text to the first row of the new column (e.g., "Cost + Tax")
4. Sum entries in existing columns whose 1st row label is "Cost" and "Tax" and store result in the below the new column "Cost + Tax"
Any help would be much appreciated.
Thanks for you time .
I'm trying to write some code that will do the following:
1. Select the last column that contains data in a worksheet
2. Inserts a blank column to the left of the selected column
3. Enter specified text to the first row of the new column (e.g., "Cost + Tax")
4. Sum entries in existing columns whose 1st row label is "Cost" and "Tax" and store result in the below the new column "Cost + Tax"
Any help would be much appreciated.
Thanks for you time .