# Search:

Type: Posts; User: ERed1; Keyword(s):

Page 1 of 5 1

1. ## Thread: Function to find specific value and return

by ERed1
Replies
9
Views
59

### Re: Function to find specific value and return

Gotcha. I'm gonna see what I can do with it. Thanks for the help.
2. ## Thread: Function to find specific value and return

by ERed1
Replies
9
Views
59

### Re: Function to find specific value and return

What is the first part of the code doing?
"=IF(ISNA(VLOOKUP(A2,Sheet2!\$A\$2:\$B\$10,2,0)),"",...)
3. ## Thread: Function to find specific value and return

by ERed1
Replies
9
Views
59

### Re: Function to find specific value and return

I am pretty Sure I got it to work with what I need. Thanks for the help Fluff!
4. ## Thread: Function to find specific value and return

by ERed1
Replies
9
Views
59

### Re: Function to find specific value and return

It should just return a blank. I would also like it to do it for cat and frog too, if that makes sense.
5. ## Thread: Function to find specific value and return

by ERed1
Replies
9
Views
59

### Function to find specific value and return

Hi all,

So I need help writing a formula, not in vba, that looks at a number in column A, then looks at another sheet. Finds the value from column A in a list. If a value isn't found, it returns...
6. ## Thread: Locking specific cells

by ERed1
Replies
9
Views
93

### Re: Locking specific cells

I got it to work. Thanks for all of the help

by ERed1
Replies
9
Views
93

It is manual
8. ## Thread: Locking specific cells

by ERed1
Replies
9
Views
93

### Re: Locking specific cells

Awesome. I got it to work for that section and the rest. I was having difficulty with one part and trying to put it in.
If Not Intersect(Target, Range("B19")) Is Nothing Then
...
9. ## Thread: Locking specific cells

by ERed1
Replies
9
Views
93

### Re: Locking specific cells

It's still throwing the same code. I should have also said that I am trying to run code specific to sheet one for example:

If Range("B19").Value = "Generic" Then ...
10. ## Thread: Locking specific cells

by ERed1
Replies
9
Views
93

### Locking specific cells

Hi all,

I need some help fixing this code.

Worksheets("Sheet1").Range("A6:A167").Locked = FalseWorksheets("Sheet1").Range("C6:C167").Locked = False

I...
11. ## Thread: Easier way to select multiple columns in excel

by ERed1
Replies
3
Views
33

### Re: Easier way to select multiple columns in excel

Thanks for the help. That worked.
12. ## Thread: Easier way to select multiple columns in excel

by ERed1
Replies
3
Views
33

### Easier way to select multiple columns in excel

Hi all,

So I am writing a code to select multiple columns. Here is what my code would look like:

Columns("B:B")...
Columns ("E:E")...
Columns ("H:H")...

Is there an easier way of...
13. ## Thread: Using VBA, easy way to copy data from a few tabs into 1

by ERed1
Replies
5
Views
52

### Re: Using VBA, easy way to copy data from a few tabs into 1

That worked perfectly. Thanks for the help again Fluff!
14. ## Thread: Using VBA, easy way to copy data from a few tabs into 1

by ERed1
Replies
5
Views
52

### Re: Using VBA, easy way to copy data from a few tabs into 1

This worked great. I have headers on the sheets that are being copied into one. So I have a header half way through my data. Got a quick way of changing that?
15. ## Thread: Using VBA, easy way to copy data from a few tabs into 1

by ERed1
Replies
5
Views
52

### Using VBA, easy way to copy data from a few tabs into 1

Hi all,

So I have a few tabs with changing names, that sometimes are there and others there aren't. For example. I will always have a "Sheet1" then after that they may not be there, "Sheet1 (2)",...
16. ## Thread: Easy way to delete Tabs

by ERed1
Replies
12
Views
124

### Re: Easy way to delete Tabs

I did the change that you just said Fluff, and I got that to work.

Thank you both for the help!
17. ## Thread: Easy way to delete Tabs

by ERed1
Replies
12
Views
124

### Re: Easy way to delete Tabs

Dim ws As Worksheet For Each ws In Worksheets
If Left(ws.Name, 7) = "Sheet1" Then ws.Delete
Next ws

For Each ws In Worksheets
If ws.Name Like "*(*)" Then ws.Delete
...
18. ## Thread: Easy way to delete Tabs

by ERed1
Replies
12
Views
124

### Re: Easy way to delete Tabs

So I just noticed this; they are named "Sheet1". There isn't a space in there.
19. ## Thread: Easy way to delete Tabs

by ERed1
Replies
12
Views
124

### Re: Easy way to delete Tabs

So I tried both of your code, and Fluff's cleared the ones after, while Joe's cleared the first sheet, so I just put both of those in there and it works great that way.
20. ## Thread: Easy way to delete Tabs

by ERed1
Replies
12
Views
124

### Re: Easy way to delete Tabs

So I implemented this into my code, and I got it to delete "Sheet 1 (2)", but it isn't deleting "Sheet 1". So Here is what my code looks like with yours in it.
...
21. ## Thread: Easy way to delete Tabs

by ERed1
Replies
12
Views
124

### Easy way to delete Tabs

Hi all,

I was just wondering if anyone new a macro that deleted specific tabs based on part their name. I have a macro that creates new tabs, but every tab has "Sheet 1" in it, the later tabs have...
22. ## Thread: Copying Sheets Into One

by ERed1
Replies
1
Views
102

### Copying Sheets Into One

Hi all,

I have a macro that copies different excel workbooks into one workbook, except they all have their own sheet. When the files get copied into the one big file and get their own sheets, the...
23. ## Thread: Selecting Row based on a Cell Value

by ERed1
Replies
9
Views
1,139

### Re: Selecting Row based on a Cell Value

This worked perfectly. Thank you.
24. ## Thread: Selecting Row based on a Cell Value

by ERed1
Replies
9
Views
1,139

### Re: Selecting Row based on a Cell Value

The whole row should have red font, if the cell in AH has "Black" as a cell value.
25. ## Thread: Selecting Row based on a Cell Value

by ERed1
Replies
9
Views
1,139

### Re: Selecting Row based on a Cell Value

Haha didn't see that. I would like just the font to be red if possible.
Results 1 to 25 of 102
Page 1 of 5 1