Search:

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

Search: Search took 0.00 seconds.

  1. Re: VBA: Split data into multiple worksheets based on column

    Oh okay, I see. Thanks for the explanation. I really appreciate the help!
  2. Re: VBA: Split data into multiple worksheets based on column

    Thanks mirabeau. That macro is a LOT faster. But it's giving me an error on the name for the sheet:

    Runtime 1004:
    Name can't exceed 31 char
    name cannot contain characters: : /\?*
    You did not...
  3. Re: VBA: Split data into multiple worksheets based on column

    Wow, thanks so much mirabeau! That worked like a charm!

    Do you have a favorite version of this that you would recommend? If so, please share. I'd love to check it out.

    Thanks again!
  4. VBA: Split data into multiple worksheets based on column

    I'm trying to get this code I found (from How to split data into multiple worksheets based on column in Excel?) to work, but it's giving me an error.


    Sub parse_data()
    Dim lr As Long
    ...
  5. Re: Excel VBA: Move filenames listed in Column to Folder path in Contents of cell

    Thanks for the kind reply!

    Yes, I looked through those threads before I posted here, but like I said, they aren't quite doing what I'm looking for. Namely, a conditional move based on file name...
  6. Excel VBA: Move filenames listed in Column to Folder path in Contents of cell

    Hi folks!

    I was wondering if anyone happen to know or have a macro that can move files



    <tbody>
    Bad
    Good
  7. Re: Copy Formula Horizontally, Incrementing Row

    The first one you posted worked great.

    "Mapping" Tab Data starts at A2.

    This formula is in R2:


    =IF(OR((AND(OR(ISNUMBER(FIND(INDIRECT("'Mapping'!$B"&COLUMNS($R:S)),$D2)),...
  8. Re: Copy Formula Horizontally, Incrementing Row

    Genius!!! That worked perfectly! Thanks so much for this!
  9. Re: Multiple Conditions: IF(ISNUMBER(FIND(this)) ... but with a NOT?

    Thanks so much for the reply! It worked! Here was the formula I used:


    =IF(OR(AND(ISERROR(FIND(Mapping!$B$37,D2)),ISNUMBER(FIND(Mapping!$B$38,$D2))),$M2=Mapping!$A$38),1,0)
  10. Multiple Conditions: IF(ISNUMBER(FIND(this)) ... but with a NOT?

    Hi there,

    This is the formula that I'm working from:


    =IF(OR(ISNUMBER(FIND(Mapping!$B$38,$D2)),$M2=Mapping!$A$38),1,)

    I want to add the following as an exception that, if true, would...
  11. Re: Copy Formula Horizontally, Incrementing Row

    Okay, I have another question actually.

    So the above works for incrementing row in a simple formula. But what if it's a complex IF formula like this:

    ...
  12. Re: Copy Formula Horizontally, Incrementing Row

    Actually, to make the Index Formula more simple, and sum everything up...


    =INDEX('Example Tab'!$A:$A,COLUMNS($A:B))

    Indirect...


    =INDIRECT("'Example Tab'!$A"&COLUMNS($A:B))
  13. Re: Copy Formula Horizontally, Incrementing Row

    Markmzz, You're absolutely right. I'm not sure what I was doing wrong.

    Both your INDIRECT and the INDEX formulas work to accomplish what I was doing. However, the INDEX Formula above needed to...
  14. Re: Copy Formula Horizontally, Incrementing Row

    Thanks for the replies! Unfortunately neither of those worked. However, I think I found an easy solution.

    1. AutoCopy/fill the formula down (instead of right) (e.g. starting at A1)
    2. Copy...
  15. Copy Formula Horizontally, Incrementing Row

    I'm trying to figure out how to automatically increment the row reference in a formula copied horizontally.

    Example:

    <tbody>
    ='Example Tab'!$A2

    ='Example Tab'!$A3

    ='Example Tab'!$A4
  16. Re: Formula?: IF ("Tyrion" is Here OR There) AND IF ("Crossbow" is over here) = "He will end Joffrey"

    That worked! Thanks so much!!!

    And I've Read all the books... no spoilers here though. I Hope Joffrey gets a much more....interesting end. Hehe.
  17. Formula?: IF ("Tyrion" is Here OR There) AND IF ("Crossbow" is over here) = "He will end Joffrey"

    Okay first just let me say WOW AWESOME FORUM AND SITE!!! I'm really pretty new to Excel formulas, but I'm totally geeking out on it. It's so cool!

    Anyway, I'm trying to get a formula to do the...
Results 1 to 17 of 17