Hi,
I need to create a dynamic formula that refers to the tab name which will change depening on the date/month that file is created for. Is there functionality in Excel that can have a formula refer to the tab-name that corresponds with a column header. I'll have daily tabs and daily columns for each month. Basically the summary tab needs to be able to pick up values from each daily tab and populate the corresponding day's column.
Thanks,
Tiina
I need to create a dynamic formula that refers to the tab name which will change depening on the date/month that file is created for. Is there functionality in Excel that can have a formula refer to the tab-name that corresponds with a column header. I'll have daily tabs and daily columns for each month. Basically the summary tab needs to be able to pick up values from each daily tab and populate the corresponding day's column.
Thanks,
Tiina