Posted by Brian P on November 25, 2000 7:49 PM
I am trying to grasp the Boolean thing. I have a sheet that I am collecting data on. The data that shows up on my collection sheet is dependant upon a number switch on sheet 1.
Example, if Sheet 1 cell A1=1, I want data from sheet 10 Cell A1 to show up on my collection sheet.
If Sheet 1 cell A1=2, I want data from sheet 11 Cell A1 to show up on my collection sheet
If Sheet 1 cell A1=3, I want data from sheet 12 Cell A1 to show up on my collection sheet.
I have a total of about 12 sheets, so a Nested If is out of the question, and I have no VBA experience. I would assume that Boolean logic would be the answer but I am having trouble getting it worked out.
Another wrench in the gears is that some of the cells that I am wanting to copy are text and some are numbers.