Search results for query: *

Thanks! Yes... the sheet name is identical.

I have a bunch of files that I need to unhide a worksheet in. The sheet has the same name in all files and all files are located in one folder. How would I do this? Thanks.

Thank you! It worked... but now there is another issue... in the BigTable, some records have zipcodes with the 4 digit extension and some don't. The zipcode file doesn't have any extensions. Is there anyway to use a wild card with this?

As of now, the criteria won't be changing. Would that make it easier? He's some more detail. Each month, I will get a file of about 65,000 property records. I need to exclude any records located in hurricane impacted areas - as defined by the 2000+ zipcodes.

I do need more info on both solutions.... Thank you!

I have a table with about 65,000 records and need to filter out any records with specific zip codes - there are over 2000. What's the easiest way to do this?

I don't know SQL programing.

I want to run a crosstab query and a duplicate query off an exisiting query, however, one of the fields does not show up in the selection choices. Why would this happen?What can I do?

Why am I getting this error when I have "Do" in the code? Sub Issue() Range("A2").Select Do While ActiveCell.Value <> "" ActiveCell.Offset(1, 0).Select If ActiveCell = "" Then Selection.EntireRow.Hidden = True Loop End If End Sub

Duplicates

If that makes any sense... here we go I want to assign items in column A to random people. I created a table where 1 = jack, 2 = jill... etc. Colum B selects a random # between 1 and (cell) with the cell containing the number of people available for assignment. So if there are 12 people...

I have a macro that will run on many different .csv files. The worksheet in each file is named as the file. I want it named "ABC" in all files. What code can I use to rename the worksheet in each file even though all the worksheets have different names? Thanks,

I defined the range after i put it in the cell... I didn't put it directly into the reference. It works... Thank you so much for your patience and help!

I cut and pasted the OFFSET formula when I didn't get a list returned.... Does the OFFSET formula go in a cell?

It is all in Sheet1 1. the Primary list is named "Col1" located in column N. a N2:N11 b N12:N33 c N34:N52 2. the Secondary list is named "Col2" located in column O. 3. I assigned the name "VarList" to the OFFSET formula and use it in column P. 4. I reference "VarList" in the...

Thank you so much!! I've got the list now. The only problem is when I select "c" in the 1st column, the list comes back with "#Value!" for each "a" or "b" item. How can I get it to only show a list for what is selected in the 1st column?

It's working, but I am only getting 1 item in the drop down list... Here's my VarList: =OFFSET(Sheet1!$O$1,MATCH(Sheet1!$D$10,Column A,0),0,COUNTIF(Column A,Sheet1!$D$10),1)

Thanks Skip! What does B1 reference?

I know this must be simple, but I have spent the morning searching posts and trying on my own... I have cell D10 with data validation that allows the user to pick from "A, B, or C." If they select "A," I want "list A" to appear in either cell E10 or a combo box, "B" and "list B" etc. Here's...

1. Yes 2. It's not running from a module. It's attached to the worksheet.