copy & transfer data

  1. C

    Macro Help - Copy Data fro mmultiple CSV Files

    I need help creating a macro. I have 10+ CSV Files and a single master excel 2010 file. The CSV Files are updated by seperate individuals and I need to delete the contents of rows 8 until the end of the document. I then need to copy the Data starting in A2 from the csv Files and copy it to C8...
  2. S

    Making a new worksheet for every unique name on a list but I need the worksheet to be a copy of a template

    I am a novice when it comes to making macros so I am in desperate need of help. I have two worksheets, one with data that will be updated with new data everyday and the other, a template that the data needs to fill in by each row accordingly. However the template needs to be a copy of the unique...
  3. L

    Macro to Copy Cell Contents to new Cell Row

    I've seen several threads here for this function but haven't been able to successfully modify those codes to work in my situation. I have a form I created on Spreadsheet1 I named M635Frm used to enter data that will stored in a database format on SpreadSheet2 (Named M635Db). I viewd a couple...
  4. H

    VBA copy dynamic range from multi sheet to sheet3

    I am trying to copy a range of valid cells "non-blank" from "sheet_a" ,"sheet_b" ,"sheet_c" to "sheet3" i got some help and i was successful to copy from one sheet only. how to copy from all the sheets listed from the same workbook. following is the VBA code i am using Sub CopySample()...
  5. I

    Copy Data From Specific Sheet In Workbook

    Hi, I wonder whether someone may be able to help me please. I'm using the code below to allow the user to select multiple Excel files, copy a range of data before amalgamating them into a 'Master' spreadsheet. Sub BigMerge() Set DestWB = ActiveWorkbook SourceSheet = "Combined" StartRow...
  6. N

    Need help with "compare, find, copy adjacent, replace value" formula

    I'm in desperate need of help for a formula in xls that can do the following. Suppose I have two price lists containing part numbers (column A) and prices (column B). Price list X and Price list Y. Price list X has say 500 rows (part numbers which may be repeated) and prices for each part...
  7. A

    Macros - Copy data from one worksheet to another with date constraint

    Hi everyone, I am fairly new to excel and need help with excel programming / macros. I am project manager and trying to develop project financial tracking sheet. I have created a sheet to track "Project Forecast effort" and "Project Actual effort". At the start of the project I create project...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top