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 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 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
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!
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)
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.