Closed Thread
Results 1 to 3 of 3

Copy Master worksheet data to other sheets!

  1. #1
    Registered User
    Join Date
    10-20-2008
    Location
    Illinois
    Posts
    2

    Copy Master worksheet data to other sheets!

    I need to make a macro that basically copies entries from a master worksheet to other worksheets in the same workbook. The entries will be entered into the main worksheet first and then I need a button or hotkey that runs the macro. The entries are to be placed in the appropriate value stream worksheet once I run the macro. I am new to using macros so I'm not sure where to start on this. Thanks for any help.

    Columns A thru I are the items that are manually entered and need to be copied. I will need the ability to update as the date due and date completed columns are updated on the master list.
    Attached Files Attached Files
    Last edited by akepler; 10-20-2008 at 01:50 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,259
    Hello akepler,

    Welcome to the Forum!

    The title of your post is important. It will help you get your question answered quickly and correctly. It also helps members and guests to find answers to their questions.

    A better title would be "Copy Master worksheet data to other sheets".

    If you need helping in changing the title of your post let me know. Click here to send me a message.

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    10-20-2008
    Location
    India
    Posts
    8
    Hello ,

    You can create a macro that looks like this

    Please Login or Register  to view this content.
    Hope above macro helps you.
    Last edited by shg; 10-20-2008 at 06:55 PM. Reason: add code tags

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to populate a cell and then execute another macro
    By andrewc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-29-2008, 02:19 PM
  2. macro to create a macro?
    By jojotherider in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2008, 08:34 PM
  3. Macro for copy/insert into expanding table
    By Soslowgt in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-06-2008, 07:24 PM
  4. How to splitt texts into words? (collecting word and compounds)
    By wali in forum Excel Programming / VBA / Macros
    Replies: 53
    Last Post: 02-03-2008, 04:06 AM
  5. Conditional formatting macro (highlight macro)
    By c991257 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2007, 02:46 PM

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