+ Reply to Thread
Results 1 to 6 of 6

Update data from other sheets based on Row Header

  1. #1
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Question Update data from other sheets based on Row Header

    Hi Folks,

    I have a workbook with a Master sheet and other several sheets. What I am looking for in the master sheet i want to get all other sheets data based on header titles. I have attached a file of what I'm trying to accomplish. Thanks in advance for your expertise!



    Joshi
    Attached Files Attached Files
    Last edited by krjoshi; 12-18-2011 at 10:42 AM.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: VBA Help Needed : Update data from other sheets based on Rows Header (Title).

    krjoshi,


    Detach/open workbook CommandButton1 wM TitleAray all ws - krjoshi - EF806083 - SDG15.xlsm and click on the command button on worksheet Master.


    Each time you click on the command button, any prior data will be cleared.


    If you want to use the macro on another workbook:


    Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

    1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
    2. Select the worksheet Master where your code is to run
    3. Right click on the sheet tab and choose View Code, to open the Visual Basic Editor
    4. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
    5. Press the keys ALT + Q to exit the Editor, and return to Excel


    Please Login or Register  to view this content.


    Worksheet Master will have to have a CommandButton1.


    Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Question Re: VBA Help Needed : Update data from other sheets based on Rows Header (Title).

    Hi Stanley,
    Great job! Thanks a lot for your time. But still I am getting some error. Please find attached the workbook with my comments. I hope you can resolve. Please help me.

    Thanks

    Joshi
    Attached Files Attached Files
    Last edited by krjoshi; 12-18-2011 at 02:32 AM.

  4. #4
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Update data from other sheets based on Row Header

    krjoshi,

    Your latest workbook, worksheet Master, had a title in cell C2 WO#, but the Data worksheets contained the title WO No

    I have changed the title on worksheet Master, cell C2 to WO No


    Detach/open workbook CommandButton1 wM TitleAray all ws - V2 - krjoshi - EF806083 - SDG15.xlsm and click on the command button on worksheet Master.
    Last edited by stanleydgromjr; 12-18-2011 at 10:13 AM.

  5. #5
    Forum Contributor
    Join Date
    10-30-2011
    Location
    Doha
    MS-Off Ver
    MS office 365
    Posts
    701

    Re: Update data from other sheets based on Row Header

    Hi Stanley,

    Great job! Its working well. Thanks a lot for your time.

    Joshi

  6. #6
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: Update data from other sheets based on Row Header

    krjoshi,

    Thanks for the feedback.

    You are very welcome. Glad I could help.

    Come back anytime.

+ 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