+ Reply to Thread
Results 1 to 17 of 17

Need help automatically insert rows with data from another spreadsheet in same excel file

  1. #1
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Need help automatically insert rows with data from another spreadsheet in same excel file

    Hi All,

    ok, here goes.. I am trying to create an excel file with multiple sheets within named Main / Section1 / Section2. Main Sheet will be the spreadsheet compiling all data from spreadsheets Section1 and Section2. Is there any way to do it so that whenever new data is entered into Section1 and Section2, new rows with the new data will be automatically inserted into Main Spreadsheet without overwriting the existing data? Would really really appreciate if someone could help me out on this.

    Many thanks.
    Attached Images Attached Images
    Last edited by songserene; 07-01-2013 at 11:28 PM.

  2. #2
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Example:

    main.jpg

    sa.jpg

    sb.jpg
    Last edited by songserene; 07-01-2013 at 11:27 PM.

  3. #3
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Hi,

    Really need some advise please.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,409

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Probably you do.

    If you took the time reading some questions, you will have read that you get better help if you add an excel file, without confidentional information.

    In that case also add the desired (expected) result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  5. #5
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Appreciate your reply. I have enclosed the excel file.

    Not sure what you meant by add the desired result, but please note that I did mention the requirements which I needed help on, in the first post of this thread.

    Thanks.
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,409

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Not sure about your question.

    But see if the result on the sheet "consolidated" is what you want.

    See the attached file.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Hi,

    Yes, it is quite similar to what I actually need and it works fantastically for me.

    Could you also give me some pointers on how to place a button in spreadsheets SectionA and SectionB which allows me to execute the function by clicking on it?

    Thanks for your great help. Appreciation x 100

  8. #8
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,409

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    I added an button on the consolidated sheet.

    The whole sheet will update after pushing the button.

    Try adding new row in sectionA (like i did) and push the button.

    Please reply if this is what you're up to.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Yes, it is even better than what I had in mind. Many thanks!

  10. #10
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,409

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Thanks for the reply.

    Glad i could help.

  11. #11
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Hi All,

    I tried using the solution provided by a helpful user previously on sheets with 6 columns and it isn't working correctly. Could someone please give me some guidance on how to compile all data into Consolidated Sheet from Sheets (SectionA, SectionB, SectionC, SectionD, SectionE) with Column C as the validating field? Also, can there be 2 rows of space dividing the 5 Sheets (SectionA, SectionB, SectionC, SectionD, SectionE) after compiling?

    Appreciate the help. Many thanks.

    Example_List.xlsm

  12. #12
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Hi,

    Can someone just give me some pointers to which part of the code I need to amend so that it will work Thanks.

  13. #13
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    153

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Dear Oeldere,

    You gave a great solution to Songserene. thats very nice.
    Actually i have the same problem to do with my worksheet please view my attached worksheet and oblige.

    Abdul Rouf
    Attached Files Attached Files
    Abdul Rouf Roofi

  14. #14
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,409

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    @roofi,

    according to the forumrules, you need to open an own question, and refer to this topic.

    please also add the desired (expected) result in your sheet.

  15. #15
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,409

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    @songserene,

    add manualy (in your workbook) how the result should be in sheet consolidation.

  16. #16
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Hi Oeldere,

    Thank you for your reply and sorry for replying late.

    I created the file manually as per your request, please find attached.

    Example_List.xlsx

    Appreciate if you could advise on how to get the results as shown in the file

    Many thanks.

  17. #17
    Registered User
    Join Date
    08-16-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Need help automatically insert rows with data from another spreadsheet in same excel f

    Hi,

    Anyone willing to help me on this?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1