+ Reply to Thread
Results 1 to 11 of 11

One Click UPDATE using VBA or Excel Functions

  1. #1
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Question One Click UPDATE using VBA or Excel Functions

    Hello...

    Is is possible to Update the master sheet with data from sub sheets in one click? Let us say we have one Master Sheet and Three sub sheets with name Morning, Afternoon, Night. I would like to have an excel function on Master sheet or an Update button on Master sheet by which if i click on that it should copy all data except labels from Morning, Afternoon, Night to Master sheets and also while copying one column i.e column G "Shifts" should get auto filled based on from which sheet the data been copied. For example- If 10 data copied from Morning sheet it should show Morning Under Shifts column for those 10 data, if data is copied from Night, it should show as Night...and so on..Hope its not much confusing. Sorry I am not an expert in such matters..Plz find the sample excel sheet below.
    Attached Files Attached Files
    Last edited by Psionicrnd; 01-05-2014 at 08:44 AM.

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: One Click UPDATE using VBA or Excel Functions

    Hi, Psionicrnd,

    Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

    Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

    Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

    http://www.mrexcel.com/forum/excel-q...functions.html

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: One Click UPDATE using VBA or Excel Functions

    Deleted, in response to Holger's post

    Pete

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: One Click UPDATE using VBA or Excel Functions

    ^^ - Damn, what a waste of a couple of minutes.

    Guess I'll keep the code in reserve until OP indicates he will comply with the rules...

  5. #5
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: One Click UPDATE using VBA or Excel Functions

    Sorry for the confusion Gentleman actually as per the rules i am aware of the of not posting same question in multiple forums. The issue is this forum has specific Track Tab as "My Posts" but the other forum does not have such specific tab, so when i posted the question there I could not find the Post link. As i tried once posting and didnt find it so I moved to here where i can keep a track. Sorry for the confusion. Do this post really valid now as i cant delete or mark closed the other post...

  6. #6
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: One Click UPDATE using VBA or Excel Functions


  7. #7
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: One Click UPDATE using VBA or Excel Functions

    Quote Originally Posted by HaHoBe View Post
    Nope...this is not Me, Sir...I am only Member in this and Mr Excel :-)...and also the question that guy asked is not same as mine and the UserID is not mine...My ID on both the forums is the same i.e psionicrnd .... So please...
    Last edited by Psionicrnd; 01-05-2014 at 09:57 AM.

  8. #8
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: One Click UPDATE using VBA or Excel Functions

    I think HaHoBe should have posted in the thread http://www.excelforum.com/excel-prog...ily-basis.html...

    Regardless, there is no rule that you cannot post the same issue on multiple boards but it's simply preferred you do not. However, if you do, you are required to include links to all your posts. This is simply a matter of copying the URL from the address bar of your browser and pasting into your message.

    You should note this rule exists on just about every similar board. This thread still does not comply with the rules of the boards you have posted on

  9. #9
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: One Click UPDATE using VBA or Excel Functions

    OMG...its so so confusing now...I am wondering if my post is valid or not...what should i do next to get all on track and get help with my queries. I accepted my mistake of posting same question on here and Mr Excel...how ever I finally got that post commented commented as closed. So i think now I am clean and abide to all forum rules.....(sigh)

    MrExcel Post- http://www.mrexcel.com/forum/excel-q...functions.html
    Last edited by Psionicrnd; 01-06-2014 at 06:33 AM.

  10. #10
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: One Click UPDATE using VBA or Excel Functions

    It's not confusing - If you post the same issue on multiple boards you are required to include link to all of your posts on each board you post on...

    You posted here and on MrExcel. Your post here should have included a link to the thread on MrExcel, and your thread on MrExcel should have included a link to this thread. Including links is simply a matter of copying the URL from the address bar of your browser when viewing the thread here and pasting into your message on MrExcel and vice versa.

    Even though you asked for the thread to be closed on MrExcel, you really should add a reply with a link to this thread. [/RANT]
    _____________________________________________________________________________________________

    The code:
    Please Login or Register  to view this content.
    Add that to a Module and assign the macro UPDATE to the update button...
    Last edited by cytop; 01-05-2014 at 12:14 PM.

  11. #11
    Registered User
    Join Date
    07-08-2011
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007, Excel 2010
    Posts
    17

    Re: One Click UPDATE using VBA or Excel Functions

    Thank you Sir. It is working fine but i also see if I have any other columns with data on only Master sheet Like H, I, J etc and when i run the macro, data and columns from sub sheets gets copied after deleting other columns existing on Master sheet. Is it possible to keep columns after G on master safe and only copy those first few required columns from sub-sheets?...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. One click to update many cells
    By wkp2101 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-01-2011, 05:19 PM
  2. Userform Commandbutton does not update on click
    By asha3010 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-05-2010, 04:25 AM
  3. How to update a cell with every click
    By just66horns in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2008, 02:58 PM
  4. how to update all functions on an Excel worksheet
    By jorgefherrero in forum Excel General
    Replies: 4
    Last Post: 02-06-2008, 04:09 PM
  5. [SOLVED] how to update functions in excel sheet?
    By Inass in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-22-2005, 02:06 PM

Tags for this Thread

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