+ Reply to Thread
Results 1 to 3 of 3

Transfering data into multiple sheets in 1 workbook.

  1. #1
    Forum Contributor
    Join Date
    06-03-2008
    Location
    Northern Ireland
    MS-Off Ver
    2003
    Posts
    107

    Transfering data into multiple sheets in 1 workbook.

    Hi everyone.

    I've been given some VBA to perform a transfer of money onto different balance sheets in 1 workbook.

    The problem I have is two-fold. Please see that attached workbook.

    Within each sheet I have added a simple transfer table in the top right hand area. This allows a user to transfer funds from an opening balance on one sheet and add it to another. There are 3 years to be shown so I thought of adding 3 transfer buttons 1 for each year.

    Everything works except for the 2 problems.

    1. If you don't add a figure in the first row then it won't take away any figures entered below it.

    2. Also it takes away 6 instead of 1 if entered. Please help!!! The code is as follows

    Please Login or Register  to view this content.
    THANKS!!!!
    [code]
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi,

    The code is operating exactly as written and it will always update 6 sheets since there is nothing to avoid that.

    I've re-written the code and added a new Procedure called "Transfer" to the attached workbook. I've also added a new sheet which contains a simple table which contains the sums you want to transfer from one sheet to another. Just enter the amounts you want to see transferred into each sheet shown in the rows, from the sheet shown in the column labels, in B5:I11. Also note B1 which contains the year you want to update.

    If you use this you no longer need all the tables in F1:I8 on each sheet or the 3 buutons on each sheet. Just run the 'Transfer' macro - or attach it to a new button.

    HTH
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-03-2008
    Location
    Northern Ireland
    MS-Off Ver
    2003
    Posts
    107
    Richard,

    Thanks for your time and help. I actually re-wrote the code to do what I wanted. (see below). Your idea of adding a transfer sheet is an excellent idea. I think I'll add this to the workbook as an overview. It would be nice to get the sheet to copy any actions from the macro's in the other sheets to give an overview of what has happened.
    Please Login or Register  to view this content.
    Last edited by Steve-B; 09-08-2008 at 11:20 AM.

+ 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. Data gathering from multiple sheets
    By chris.leng in forum Excel - New Users/Basics
    Replies: 17
    Last Post: 08-15-2008, 04:43 AM
  2. group data from multiple worksheets into a seperate workbook
    By ashlegg in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-19-2008, 06:30 AM
  3. SUMPRODUCT across Multiple Sheets in the same workbook
    By Adrian17 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-23-2007, 01:41 PM
  4. Inputing/Arranging Data Across Multiple Sheets
    By jim_dickey in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2007, 04:38 AM
  5. Updating data references across multiple books and sheets
    By jclu in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-14-2007, 12:29 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