Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: VBA Consolidation

  1. #11
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, I've got it.

    Array("Sheet1!R11C1:R27C4", "Sheet2!R11C1:R27C4", "Sheet3!R11C1:R27C4")

    ...is not the same as the string you are compiling. The array function is not accepting the string with commas as compiled in the loop.

    Have you tried a method similar to my first reply, where you just do a copy and insert-paste actually in the loop? This is tried and tested method by me many times.

    Apologies for my earlier stupidity, am a bit slow tonight!

    <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;"> DALEY :P </td></table>

  2. #12
    New Member
    Join Date
    Apr 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wouldn't that method just copy/paste and not sum up similiar items?

    I haven't got to see my starting point yet, but it sounds like the initial spreadsheet will have around 90 workssheets.

    I've written a macro that does a vlookup using cell A3's and a table with "A Group", "B Group" etc. to determine if it now goes to workbook 1, 2, 3, or 4. Then it copies the tab to the corrsponding workbook.

    This last part would consolidate the worksheets in the individual new workbooks. I was hoping not to hard code in the sheet names as they may change on occasion.

    Your help has been very appreciated!!

    [ This Message was edited by: Bruce on 2002-04-19 15:19 ]

  3. #13
    Board Regular
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    167
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    could you do the consolidate within the loop, consolidating one sheet at a time so that no array is required?

    <table style="background-color:#0e54be" cellspacing="1" cellpadding="2"><td style="background-color:#ceffff;font-family:arial;color:#072c63;font-size:8pt;"> DALEY :P </td></table>

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •