Have a workbook with sheets Dataentry, Printout, sheet1, sheet2,.......sheet7.
Cell on Dataentry will contains the text sheet#. Want to use this cell value as the "sheet name" in a formula on sheet Printout that references a value on the sheet "sheet name"
Will supply an example tomorrow if what I want is not clear.
Thanks
welcome to the forum, GavJ. yes it'll probably be good if you can upload a sample excel file & show us your desired results. i'm guessing if you have the sheet name in A1 of DataEntry sheet & you want to reflect Sheet1!B1, you can use:
=INDIRECT("'"&A1&"'!B1")
if A1 is showing Sheet1, it will show you B1 value of Sheet1. if A1 is showing Sheet2, it will show you B1 value of Sheet2
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi,
Perhaps
Formula:
Please Login or Register to view this content.
where A1 on data entry contains the sheet reference. When you mentioned 'textsheet#' you rather confused me. Or are all your sheet names numbers.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Sheets are sheet1, sheet2, sheet3,.........sheet7. Sheet# is any one of sheets1 - 7. I have a userform where a sheet is selected. Data is entered on Dataentry and is transferred to the selected sheet and calculations performed on sheet Printout using values from the selected sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks