+ Reply to Thread
Results 1 to 10 of 10

data transfer between sheets

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    6

    data transfer between sheets

    I am trying to create an estimating program, I have a spreadsheet with a list of headings followed by 5 columns,
    Description: Quantity: Item: Rate: Total:
    I want to be able to pick lines (including headings) and have the picked lines list in order on a new sheet, in order chosen, ready for further formatting.
    I also need to be able to add further items to the full list as they become available.
    Questions are - is vlookup the best way to do this, does anyone have something similar I can work with.

    Thanks
    MikieD

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

    Re: data transfer between sheets

    Do you have a sample file that you can upload?

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.
    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]

  3. #3
    Registered User
    Join Date
    02-21-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: data transfer between sheets

    Please find attached,
    I have started to populate but you will see a column to the left, I would like to put a radio button (or even a 1 or an x) on the required lines and headers, then when I run a routine the chosen lines will appear on a new sheet which will give the totals at the bottom.

    many thanks

    Mike
    Attached Files Attached Files

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: data transfer between sheets

    Ok, what do you want to do after the data is copied to the other sheet? Clear the data from the current sheet along with the checkbox or x mark or clear only the x mark?

  5. #5
    Registered User
    Join Date
    02-21-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: data transfer between sheets

    I save the workbook under the client name for reference so the original copy will always be set at zero.

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: data transfer between sheets

    You mean you update the data, run the macro and then save as the file with a different name?

  7. #7
    Registered User
    Join Date
    02-21-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: data transfer between sheets

    Yes, We do this every time (currently manually) as we refer to the file for the life of the customer.

    Thank you
    Mike

  8. #8
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: data transfer between sheets

    So what will the column contain - radio button or alphabet or number?

    Do you want the totals to be put in by the macro in the new sheet?

    What should the new sheet be called?

  9. #9
    Registered User
    Join Date
    02-21-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: data transfer between sheets

    Apologies for taking a while to get back to you, I have been offline.

    The new sheet will be called 'quantities' and will list only the selected line values, I would prefer it to have a simple radio button for selection. It will have a total at the bottom and each column and will have all the calculations for the item it is listing on it's line under the headings I have on the sheet I uploaded, I will then be able to change the quantities to produce the individual quote,
    for example
    line 1 on the new sheet might be plastering I will then enter the metreage, the base cost of material and labour will already be on the transferred line from the original sheet. The totals for each line will be summed at the bottom of the columns to carry forward into a cell on another final sheet where it will have tax added and be totalled.

  10. #10
    Registered User
    Join Date
    02-21-2013
    Location
    uk
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: data transfer between sheets

    I am fairly confident at building the rest of the system, if I only knew the best way to do the above.

    Many thanks for your help

    MikieD

+ 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