Hey guys, I'm stuck on a part of the macros I'm creating. Im trying to create a table(table2), and the values in it are referenced from a table above(table1).
however, table1 is dynamic, a new column is added every two weeks.
in table2, the first set of values are the same as the last column in table 1. normally i would write something like
however, I cant do just AQ4 cause every couple weeks, the cell column will change.
1.) how can i reference the cell in the second row of the last column dynamically?
another issue is, that my manager sent me an example of how it should look like after running the macro.
in his headers in table2, he has specific names like week of August 21 or week of august 14.
The values in those cells need to be the sum of all columns from table 1 which fall within that range.
for example, the headers in table 1 are random, such as 8/14, 8/15, 8/17. so in the cells under the headers for Week of august 14, i need it to have the values from table 1 with the headers that fall within the week of the header.
2.) how do I reference specific cells which fall within a date range in the headers.
3.) i need to also make new headers with the same naming format as the weeks increase. week of september 25, etc
I know its pretty confusing. but If anyone wants to see screenshots, I can email them to you, same with the files. (i dont know how to add pictures to this forum).
any resolve would be greatly appreciated. thanks!
however, table1 is dynamic, a new column is added every two weeks.
in table2, the first set of values are the same as the last column in table 1. normally i would write something like
Code:
=AQ41.) how can i reference the cell in the second row of the last column dynamically?
another issue is, that my manager sent me an example of how it should look like after running the macro.
in his headers in table2, he has specific names like week of August 21 or week of august 14.
The values in those cells need to be the sum of all columns from table 1 which fall within that range.
for example, the headers in table 1 are random, such as 8/14, 8/15, 8/17. so in the cells under the headers for Week of august 14, i need it to have the values from table 1 with the headers that fall within the week of the header.
2.) how do I reference specific cells which fall within a date range in the headers.
3.) i need to also make new headers with the same naming format as the weeks increase. week of september 25, etc
I know its pretty confusing. but If anyone wants to see screenshots, I can email them to you, same with the files. (i dont know how to add pictures to this forum).
any resolve would be greatly appreciated. thanks!
