copy data

  1. S

    Copy Data to Master Database

    Tried the below code with minor modification to select file referred from Open 132 files and copy data into master file My problem is its not copying the entire data. Copies only few 3 or 4 rows. Please help Option Explicit Public Sub CommandButton2_Click() Dim Master As Workbook Dim...
  2. J

    How to Copy data from one sheet to another

    Hello Guru's, I am new to this form and VB macro i need help .. I get a file where i have some data , its as below if the total dr is not equal to cr then i want the data to be copied to a new sheet ...how can i create a macro for this ? <tbody> Line Account Desc dr cr dr cr 1 123 test1...
  3. V

    Copy Data From External Workbook Without Opening

    I would like to copy data from an external workbook and save it into my current workbook. There is plenty of code for this. What I have not found is how to do this without the external workbook ever opening. Is this possible and how would you do this? All I can see related to this is using the...
  4. T

    Copy data from one sheet to another while skipping blanks and certain rows

    Hi. I'm trying to copy data from one sheet to another, but I want it to skip blanks and a row that has data on it. I want C9:C12, C14:C17, C19:C22, C24:C27, and C29:C34 from Sheet1 to be moved to A8:A33 on Sheet 2. Rows 13, 18, 23, and 28 on Sheet1 need to be left out. Thank you in...
  5. B

    VBA Loop until no value and if value to copy data

    Hi Wonder can anyone help. I am trying to use a Loop and and IF and another Loop in a macro with vba. Sheet1: Sheet_Source Sheet2: Sheet_Display I have unique ID in Sheet_Source and is sorted smallest to largest and also there is some ID's duplicated so I want to: STEP 1- In Sheet_Display...
  6. N

    Copy data from one sheet to another using a specific criterion

    Hi Guys, I'm looking to copy over information from a master list of data by specifcying a specific criteria. For example: In the info below... there's a number of Index types. I would like the code to look at the range that is all of Column C (cell by cell) and look for "AS51", if its there...
  7. A

    Copy Conditional Date to New Sheet Macro

    Hello, I am trying to correct a very simple macro for filtering and copying data from "Master" sheet to a second "Complete" and third "In Progress" sheet. I would like to filter rows denoted with the data "C" in the "Master" sheet to the sheet "Complete." Rows with data "IP" will be filtered...
  8. E

    Activate other workbook

    Hello, After two days of googling (since om still a beginner) I have yet not found a solution to this (probably easy to solve) problem. I will firstly try to explain the problem and afterward the whole idea of the solution (if anyone wants to comment). I am trying to copy values from two...
  9. S

    Macro to copy data from one format to another into a different

    Hello all, So here's the situation: I download an Excel file (File A) and this file has data on products based on different regions. The regions are fixed columns and the products are always in the same order. For example, product A, product B, product C - all appear in the same order. This is...
  10. S

    Simplify copy data to different worksheet

    Hi All I am new to macro's and therefore not sure how to do this quicker. I found the following macro in another post that is very similar to what I want to do, however when I copied it over it takes a while to complete. Is there a simpler way to write this. The revamped version of the macro...
  11. K

    Excel bulk data copy to SQL server using VBA / ADO

    I am fairly familiar with recordset basics and have used Excel / VBA to interface with a back-end database in the past. I have a problem where data contained in an Excel spreadsheet is taking too long to update to a SQL server due to the many rows of data (recordset.update or updatebatch is...
  12. J

    Copy worksheets from multiple workbooks into specific sheet in master

    Hello, I am trying to use VBA to copy the entire contents (data) of "Sheet1" from multiple workbooks located under a single folder to a master workbook named Headcount Rollup Template. Each sheet should be imported to a specific tab in the master workbook. I have set up a sheet within my...

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