LinkBack URL
About LinkBacks
Vertical data to be displyed Horizontally in differnt tab with formula.
I currently have Data in tab "Sep canteen" Cells I559 to AJ559 that I want to display in another tab "Sep data" horizontally from J10 with formulas intact.
Please help me?
Vertical data to be displyed Horizontally in differnt tab with formula.
I currently have Data in tab "Sep canteen" Cells I559 to AJ559 that I want to display in another tab "Sep data" horizontally from J10 with formulas intact.
Please help me?
plz upload a sample book!
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
try below in J10
=INDEX($I$559:$AJ$559,ROWS(A$1:A1)) and Drag down
I will try that, however J10 is in another Tab, do I need that info in the formula?
Thanks' but The formula places the info horizontally, When I drag down i get the wrong data. How do I add the attachment so people can see problem?
Sep Canteen.jpgSep data.jpg
The data in yellow is the data I want to display vertically in the other sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks