My boss has a workbook with incoming call data that she updates daily. On my workbook, I take that data and further break it down.
What I'm wanting to do is have my column fill when she inputs her daily data.
In my workbook, in cell A2 I have entered the link to her data for today: ='[daily data tracking.xlsx]Inbound Calls 2024'!$T$30
Her data is in rows, so tomorrows data would be in U30, ='[daily data tracking.xlsx]Inbound Calls 2024'!$U$30, the day after that ='[daily data tracking.xlsx]Inbound Calls 2024'!$V$30, and so on.
I'm wanting to autofill my Column A (ie A2 through A30) with her data.
So A2 would contain her data from T30
A3 would contain U30
A4 would contain V30 ...and so on.
I've tried removing the $ and dragging down, but it just fills with same formula from T30. Several different combinations. Not getting results, I'd like. I'm sure this is a simple fix. Thanks in advance.
What I'm wanting to do is have my column fill when she inputs her daily data.
In my workbook, in cell A2 I have entered the link to her data for today: ='[daily data tracking.xlsx]Inbound Calls 2024'!$T$30
Her data is in rows, so tomorrows data would be in U30, ='[daily data tracking.xlsx]Inbound Calls 2024'!$U$30, the day after that ='[daily data tracking.xlsx]Inbound Calls 2024'!$V$30, and so on.
I'm wanting to autofill my Column A (ie A2 through A30) with her data.
So A2 would contain her data from T30
A3 would contain U30
A4 would contain V30 ...and so on.
I've tried removing the $ and dragging down, but it just fills with same formula from T30. Several different combinations. Not getting results, I'd like. I'm sure this is a simple fix. Thanks in advance.
