B bilboy New Member Jul 15, 2014 #1 Pls help!! How to copy Table vertically and update automatically as the source is updated??
azumi Active Member Jul 15, 2014 #2 You have your sample workbook? maybe more easy to help when see the table and you expected results Regards
You have your sample workbook? maybe more easy to help when see the table and you expected results Regards
B bilboy New Member Jul 15, 2014 #3 azumi said: You have your sample workbook? maybe more easy to help when see the table and you expected results Tanx azumi for the prompt reply, attaching d same. Regards Click to expand... Attachments Table_Sample.xlsx Table_Sample.xlsx 10.7 KB · Views: 4
azumi said: You have your sample workbook? maybe more easy to help when see the table and you expected results Tanx azumi for the prompt reply, attaching d same. Regards Click to expand...
Debraj Excel Ninja Jul 15, 2014 #4 Try this.. =INDEX('Horizontal '!$A$2:$E$26,COLUMN(A1),ROW(A1)) In Index function.. in place of ROW section use Column and vice versa for COLUMN Drag downward / right to fetch the recotrds. Last edited: Jul 15, 2014
Try this.. =INDEX('Horizontal '!$A$2:$E$26,COLUMN(A1),ROW(A1)) In Index function.. in place of ROW section use Column and vice versa for COLUMN Drag downward / right to fetch the recotrds.
B bilboy New Member Jul 15, 2014 #5 Debraj said: Try this.. =INDEX('Horizontal '!$A$2:$E$26,COLUMN(A1),ROW(A1)) In Index function.. in place of ROW section use Column and vice versa for COLUMN Drag downward / right to fetch the recotrds. Click to expand... Tanx Debraj, that was indeed helpful...
Debraj said: Try this.. =INDEX('Horizontal '!$A$2:$E$26,COLUMN(A1),ROW(A1)) In Index function.. in place of ROW section use Column and vice versa for COLUMN Drag downward / right to fetch the recotrds. Click to expand... Tanx Debraj, that was indeed helpful...
