+ Reply to Thread
Results 1 to 3 of 3

Copying and Pasting values

  1. #1
    Registered User
    Join Date
    10-20-2008
    Location
    Pennsylvania
    Posts
    28

    Copying and Pasting values

    I have a spreadsheet that I would like to automate. Everyday, I need to save these rotations and would like to put a macro in and a push button to do it automatically.

    I've included a portion of my spreadsheet. I would like it to copy the information beginning in K1. When I copy it the next day I would like it to copy beside the other information leaving two columns for visual purposes. I'd like to put one weeks worth of information in the same columns and rows, then it would increment down the appropriate cells and start the process over until 52 weeks worth of information is stored. I have a macro written to clear the information with a push of a button.

    I'm not very good with visual basic and am looking for a good book/tutorial to become more knowledgable. I would appreciate any assistance ya all may lend.

    Appreciated Wyatt12
    Attached Files Attached Files
    Last edited by VBA Noob; 01-12-2009 at 04:43 PM.

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492
    There's no information starting at K1 to copy. Please adjust your request. On your posted sample, show on Sheet2 what you'd like the result of some of the work to be, so we can at least see the work in progress.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    10-20-2008
    Location
    Pennsylvania
    Posts
    28
    Attached is what the sheets should look like. I guess you could call the first sheet the information sheet. This is where the data will be entered each day. All I want to do is copy this data to sheet2 everyday for a year.

    Thanks
    Attached Files Attached Files

+ 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