possible data validation from multiple sheets

[skyep2058]

Hello, I have an excel doc with multiple tabs, that represent different era's in a game I play. Each sheet is exactly the same except for the amounts that it takes to level a great building (column C) of that era, and the rewards for each great building (columns V-Z) as it levels. I am trying to make a main page that can do data validation to both represent the sheet number (cell A8) (Which I cannot figure out), and the level of the great building (cell A18) (Currently A18 does change how the level of the rewards work, but not for every sheet combined, just each sheet individually works). I have been researching for hours, and it just seems I cant data validate over multiple sheets into 1 sheet, but maybe i'm doing it wrong or theres another function to use. I've looked into the INDIRECT function as well but cant seem to figure it out.


This is also my first post, and I dont know how to attach my file if that will help.

[6StringJazzer]

What is the data validation you want to do?

It will certainly help to attach your file. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

[skyep2058]

I deleted a bunch of the sheets to make it an appropriate size. So on the testMain sheet, I am trying to write A8 to be a validation like this: ='NA:VF'!$A$8

NA is no age, and VF is virtual future. it goes through all sheets, trying to validate A8 to be NA, VF, and others.

Once I can do that validation, then, my next step would be to do a VLOOKUP on cells C24:C153, and V24:Z153 from cell A8 (that validation) onto the main sheet (testMain), as you switch from NA, VF, and others.

So my VLOOKUP would look like this after that is done: on cell C24 =VLOOKUP(A8, 'NA:VF'!C24:C153, 1, 0), but not sure if that would work either.

And my other data validation is on the main sheet (cell A18), looks through values of levels 1-130, and each of those have a percentage attached to it, so then the values would change if you change the era. That validation currently works because its on the current sheet, but the other validation doesn't work I think because its trying to validation a single cell from multiple sheets.

[FDibbins]

Please dont post duplicate threads (take a peek at our rules please)

Because this thread contains no real feedback, I will close this thread so you can continue on the other 1 here...
https://www.excelforum.com/excel-for...le-sheets.html