Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
referencing worksheet tabs
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="davsco, post: 12183047"] In my file, i have a separate worksheet for each day of the month (1, 2, 3, etc) that has a bunch of lines with a total in (let's say) row 10. In the last (Summary) worksheet, I have the days running left to right across the top, and in the next row, i'd like to have a formula that finds cell (let's say) A10. So under the column in the Summary worksheet that has a 1, i'd like a formula that finds the "1" above and knows to look in worksheet #1 and find cell A10. Then i'd just copy that formula over to find the same cell for days 2-31. Need help creating that formula!!! thanks!!! [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
referencing worksheet tabs
Top
