Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Function to find specific value and return

    Gotcha. I'm gonna see what I can do with it. Thanks for the help.
  2. 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. 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. 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. 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. Replies
    9
    Views
    93

    Re: Locking specific cells

    I got it to work. Thanks for all of the help
  7. Replies
    9
    Views
    93

    Re: Locking specific cells

    It is manual
  8. 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. 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. 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
    ActiveSheet.Protect Password:="abc"

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

    Thanks for the help. That worked.
  12. 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. Re: Using VBA, easy way to copy data from a few tabs into 1

    That worked perfectly. Thanks for the help again Fluff!
  14. 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. 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. 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. 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. 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. 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. 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.
    Application.DisplayAlerts = False
    ...
  21. 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. 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. Replies
    9
    Views
    1,139

    Re: Selecting Row based on a Cell Value

    This worked perfectly. Thank you.
  24. 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. 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 2 3 4