Alright, so here's what I'm trying to do:
I have a table that is 10 columns and 24 rows. It has percents in it. I need to create some tables farther down that are the same size that multiplies the percents in the first table by a certain value for each row of the new table. If it makes it easier to understand the first table stretches from column D1 to M24. Then for every table farther down in the same sheet there will be numbers in column C. Let's say that In D1 is 5% and in C 101 (new table) there is 1000. Then D101 would be .05*1000.
In order to do this I wanted to read in the intial table as an array and store it. Then multiply the array by the values in column C for each table and paste the values into the table.
Let me know if this is unclear. I appreaciate the help.
Bookmarks