Ask Your Question

How do I pull from same cells on a separate tab when cells on separate tab are sorted

asked 2015-04-29 14:54:35 +0100

ml821 gravatar image

using excel 2010

Simple + calculations in cells on tab2 pulling from tab1. When I sort rows in tab1, I want the + formulas in tab2 to pull from the same row regardless of where sorted row now is located on tab1. i.e.: If cell was in row 1 prior to sort and is now in row 5, I want the + calculation to now pull from row 5.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-04-29 14:57:47 +0100

ROSt52 gravatar image

This is not a Microsoft Office forum but a LibreOffice forum. Therefor there might not be an Excel expert available.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-29 14:54:35 +0100

Seen: 16 times

Last updated: Apr 29 '15