transferring data

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...