Recent content by sazi22

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...