Formula referring to Tab Name

tiinag

New Member
Joined
Jan 12, 2003
Messages
45
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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

tiinag

New Member
Joined
Jan 12, 2003
Messages
45
Hi, I've been reading through the Indirect function questions but I think they are different as they're mostly looking for data in a different workbook, my data will all be in the same workbook. I'm looking to do a sumif formula. Can you guide me to a previous question that is similar to mine? Thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,108,910
Messages
5,525,585
Members
409,651
Latest member
Quasar Hunter

This Week's Hot Topics

Top