+ Reply to Thread
Results 1 to 2 of 2

Create new sheets based on list and transfer data to correct cells and can be updated

  1. #1
    Registered User
    Join Date
    08-01-2011
    Location
    Rome, Georgia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Create new sheets based on list and transfer data to correct cells and can be updated

    Here's what I'm looking for. I track the giving at our church and want to simplify my job, duh.
    My 1st sheet (named "Givers")will have data manually input every time there is a new giver. Row 1 will be the headers so data will start in row 2. Column A will be the name, B the street address, C city state zip, D phone number.
    My 2nd sheet (named "Blank" is a blank copy of our giving record page that has a block for every weeks contributions for that giver (this sheet is updated with formulas I've already made and use).
    Every time I add a new giver I want to run a macro that will ignore the givers its already made sheets for, copy sheet 2 "Blank", change the sheet name to the name from column A of the new row, and then copy column A of that row to the new sheet cell B10, column B to B11, column C to B12, and column C to B13.

    Thanks in advance for the help. I'm pretty good with formulas but not so much with macros.

  2. #2
    Administrator arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,147

    Re: Create new sheets based on list and transfer data to correct cells and can be upd

    Why dont you attach a sample workbook? It will be easier for us to assist you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ 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