transferring data

  1. L

    How to transfer specific data from one workbook to another using vba

    Hi, I am very new in the use of excel vba and require some advice. My source data is a master spreadsheet that has column A to I filled with information. All subsequent workbooks will have the same headers. My queries is in 2 parts. Part 1 The master spreadsheet contains the workload of a...
  2. H

    How Automatically Transfer Data from one of two columns to another sheet & another Workbook

    I have a list of appliances with several columns, but two of the columns have pricing information, I would prefer to transfer to another workbook. If this is not possible, then transfer to another worksheet. My first Excel Workbook is called RetailDeck. The second Workbook is called...
  3. M

    Macro needed to copy data from master sheet to other worksheets (but maintains formulas)

    Hi, I have a macro that currently sends all my data from a master spreadsheet to individual worksheets. It uses a column header to determine what data goes to what worksheets. The only issue I have is that this formula doesn't maintain formulas, it pastes values instead. Does anyone have a...
  4. tsroque

    VBA to Transfer Data from Worksheet to Worksheet and Skip Row

    I have a data table of almost 7000 products. I only need 3 of the columns for my final report (J, K, and O...Part Number, Description and Price). What is a quick and easy way to transfer defined columns to another worksheet (starting row 7, in columns A, C and E) and have a blank row between...
  5. A

    transfering data from one book to another, uptating automatically, combining data

    I have two seperate files in excel and I need to keep both. One contains sheets that records the individual sales of each employee for all the time working in the company, the other one includes all the sales of the company (includes all employees) for each month, it has a tab for each month...
  6. B

    VBA: Please Help : Need Worksheet to Workbook Code

    I have a "Master spreadsheet" that with a macro I transfer data into from about 12 workbooks daily. I am wanting a "additional workbook" with the same data but as read only with a different name . On the additional workbook I want a comand button that will retrieve all new data that has not...
  7. C

    Type Mismatch in Macro that sends excel data to access.

    I have an type mismatch error that occurs on the fifth line of the code. Set rs = db.OpenRecordset("Header_New", dbOpenTable). I don't know enough about OpenRecordset command but from what I gathered from Microsoft the syntax is correct, but I may be wrong. Is there a specific reference that I...
  8. D

    transferring a row of data in a column, please i need help

    I am using excel2007 and i have 2 sheets in my workbook on the first sheet i have the input data sheet Name ____ b-day ____ age ____ sex ____ and an encode button with the syntax like this... inputdata = Sheet2.Range("a65536").End(xlUp).Column + 1 Sheet2.Cells(inputdata, 1).Resize(1...
  9. K

    Grouping information from several workbooks into one

    I have 9 separate workbooks with approx. 7-8 spreadsheets in each...they belong to one of each district for our company. What I am trying to accomplish is to have totals from each Workbook add up in one separate Workbook that can be viewed instead of sifting through all of them. Is this...
  10. C

    I have no idea even how to ask this! LOL

    I use an excel template that I designed for estimating. In the template, I "Save As" each time with a new client or estimate that I do, to create a unique Excel Workbook. What I want to do, is figure out how to get the value in a certain cell (total of the estimate), to go to another Excel file...
  11. B

    Transfer multiple info from 1 worksheet to another if certain critera is met

    I am trying to create a spread sheet for my company to track specific company information. They have a ton of forms we have to fill out manually that has a lot of redundent information... and I have been able to create a group of linked work sheets that can fill in all most all the worksheets...
  12. S

    Data transfer from variable source

    I need to transfer data from another spreadsheet. The title of the current spreadsheet is 01-10-09.xls and I need to get data from spreadsheet 01-09-09.xls (the day before) I already have the formula that gives me the day before in cell C40, so I need a formula that uses the date in cell C40 as...
  13. S

    Data transfer from another spreadsheet

    Now I need to transfer data from another spreadsheet. The title of the current spreadsheet is 01-09-09.xls and I need to get data from spreadsheet 01-08-09.xls (the day before) I already have the formula that gives me the day before in cell C40, so I need a formula that uses the date in cell C40...
  14. S

    Date adjustment

    Every day I have to put together a report. There is a master file for the report that I copy and paste, and then rename for the appropriate date in mm-dd-yy format. Is there a formula that I can save on the master file so that I can pull numbers from the previous days report? For example I copy...
  15. sridharprahlad

    Transferring data cell by cell from Excel to VB

    Hi.. I need to transfer a excel cell value in to my macro code. I'm trying from past 2 days, but not getting it. I'm automating the process of sending an Excel book to the selected recipients through outlook. For that i need to put recipient email address in ".To" of macro code. How to...

Some videos you may like

This Week's Hot Topics

Top