Search:

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

Search: Search took 0.00 seconds.

  1. Macro to copy and paste a variable range between worksheets

    What is the most efficient way to take all of the values from A2 down in worksheet 1 and past it into worksheet 2 starting with A7? The issue I am running into the is number of values I will be...
  2. Re: Combining Multiple Columns into one column without any blank cells

    fortunately, the list of values is actually student names and grade levels, so yeah 0 is not a valid return.
  3. Re: Combining Multiple Columns into one column without any blank cells

    Vog, you are a genius. That last one did it.

    Thank you so much for the help.
  4. Re: Combining Multiple Columns into one column without any blank cells

    No luck. Maybe there is a better way to do it than with copying from the columns, would it help to know what I was trying to accomplish?
  5. Re: Combining Multiple Columns into one column without any blank cells

    Still returning the 0s when I run it.
  6. Re: Combining Multiple Columns into one column without any blank cells

    Sorry, one more question:

    The Columns im copying from are based off formulas. Some of the cells being copied are seen as empty but in actuality contain "". Excel is copying this and showing a...
  7. Re: Combining Multiple Columns into one column without any blank cells

    Thanks, definitely working now.
  8. Re: Combining Multiple Columns into one column without any blank cells

    Is it possible the reason the macro is taking awhile to work is because the data Im copying is the result of a formula and not just text?
  9. Re: Combining Multiple Columns into one column without any blank cells

    on that one sheet it isnt all that big. Maybe 100 rows or so per column. Other pages in the workbook have 1000s of rows, but I only need the macro for the first worksheet. Will that change run time?
  10. Re: Combining Multiple Columns into one column without any blank cells

    norulen,

    Thanks, It seems to do the job. Out of curiousity, how long does it take you to run it? When I run it, the row #s flash yellow for a while, and it looks like Excel is locking up. Im...
  11. Re: Combining Multiple Columns into one column without any blank cells

    Ok, I did that. It definitely only copied column B and C for me
  12. Re: Combining Multiple Columns into one column without any blank cells

    there arent any blanks in the original data. Is there anything special I have to do to run the macro? I just have been hitting the macro tab and clicking run
  13. Re: Combining Multiple Columns into one column without any blank cells

    VoG,
    When I run it, its only filling in from column B and C
  14. Re: Combining Multiple Columns into one column without any blank cells

    I copied his macro code exactly as it was listed in his post. Is there something else I need to add?
  15. Re: Combining Multiple Columns into one column without any blank cells

    Norulen,

    It definitely copied all 3 columns, except it started the values from column C at cell A500 and column D at cell A1000 with a bunch of blanks in-between. Any way to fix that?
  16. Re: Combining Multiple Columns into one column without any blank cells

    Norulen, maybe this will help clarify, I have data in column B, C, and D. The number of entries I have in each column changes. I want column A to look like this automatically

    B1
    B2
    C1
    C2
    C3...
  17. Re: Combining Multiple Columns into one column without any blank cells

    Let me clarify a bit, because I think my phrasing was confusing. I want it to list what is in column B first, and then after the last thing from column B, list the first from thing column C, and then...
  18. Combining Multiple Columns into one column without any blank cells

    I need to be able to combine 3 columns with ranges that may change into one column without any blank cells.

    For example, I have columns B, C and D filled with data, but the number of cells in each...
Results 1 to 18 of 18