copy & paste macro

I am using Excel 2010 on Windows 7 Professional. I have multiple excel workbooks (.xlsx) in a folder and i want to copy the value (not formula) from cell $C$5 and $D$7 into my Admin workbook that the VBA will be running in. I would like the value from each excel workbook to be placed in one...

Hi, I am totally new to VBA scripting. Here is what I want to achieve - I have an excel file wbA with worksheets ws1,ws2,ws3. I want to write a VBA macro that creates an excel file wbB in a given path and copies all 3 work sheets into wbB (wbB will also have ws1, ws2 and ws3 - same names as...

Hello, I am still a beginner to macros and learn quickly by reading forums on other's experiences with running macros. So let me explain what I am trying to do and I believe I am failing miserably. I am wanting to get the macro to copy the date from sheet 1 and paste it is cell A1 on sheet two...

Hi everyone! I'm Pedro Bragança from Brazil! I'm a newbie in VBA excel and its codes. I want to develop a code that copy row after row if the macro match a certain condition in the workbook. When it match a condition like Aline/Carol/Karine, it open another workbook and copy the row selected (1...

Hi, Can anyone please help me optimize the below code? I need it to run faster by selecting multiple rows at once on sheet "Pipe List" based on the criteria in C2 on sheet "pipeline details" and copying them all over together to sheet "Pipeline Details". Right now my code copies them...

Good Afternoon, this is my first question though I have been benefiting from surfing these forums for years. My VBA skill is spotty and often cobbled together without deep understanding of why stuff works! Slowly learning though. I currently have an excel tracking document that I use in...

Hello - first time poster, long time reader. I am having difficulty with the second copy/paste functionality in a macro. Basically, when a 'complete' button is hit, the macro should copy from sheet A and past on sheet C, and then copy sheet B and paste on sheet B. Pretty basic stuff. This macro...

Hi, I am very new to VBA and would be happy if someone was to refer me to another post where this was answered or where I can get more information so I can learn more however I have the following scenario that I am hoping to solve. I have two worksheets Invoice Summary and Outstanding...

I am trying to append data into one workbook based on conditions. here are the conditions that I am trying to add. 1. If workbook name contains ts.xlsm filter column 5 Criteria1:="<10001" and copy and paste into master workbook 2. If workbook name contains sa.xlsm filter column 5...

Hello, Firstly apologies if this has been asked before - I have tried search but haven't quite found what I am looking for. I want to be able to copy data from one worksheet (Raw) to another (Accounts). Both Raw and Accounts already have data and I would like the copy to be additive - i.e...

Hi, i am trying to copy multiple Range("d1, f3, f4, f6:f9, d13:j32, d35:j54, d57:j76, d79:j98") and want to paste the copied data in the same range in the specific worksheet. my current worksheet - file:///C:\Users\ebineg\Documents\source.xlsx (sheet1) my destined worksheet -...

This is my current attempt at copying data from one tab and pasting into a table on a different tab. I began modifying the code below. The text highlighted in yellow is where I need help. Essentially, here are the two scenarios: ONE- If F5 on the "Instructions" tabs = 1, then copy columns H:J...

Hi All, I have a spreadsheet with two worksheets. what i would like to do is when a cell within column D on worksheet 2 for example is double-clicked on, it will copy the data from that cell into cell B2 on worksheet 1. Likewise, if possible, I would like to make it so that double clicking on...

Hi I am am making a excel doc that I will be using to generate quotes. I have a couple combo boxes a text box that will has text automatically generated based on the combo boxes and a table below. I need all the data that has been selected and entered to be "Exported" to another sheet when a...

Alright I've figured out a lot of ways to copy and paste data, but none work how I want them to. If I have set cells and ranges from sheet 1: B3,B10,B17,B24,B31,B38,B45(Cells) C2:H7,C9:H14,C16:H21:C23:H28...

<colgroup><col span="3"><col></colgroup><tbody> A Cloumn` B Column C Column D Column Good 52 1 4/12/2017 0:00 Good 53 1 4/12/2017 0:00 Good 4234 1 4/12/2017 0:00 Good 5232 1 4/12/2017 0:00 Good 42342 1 4/12/2017 0:00 Good 24442 1 3/30/2018 0:00 Bad 41233 0 4/12/2017 0:00...

Hi, I am a very new employee in the company and just started learning VBA. Now I have a project to write VBA code and create a summary sheet by dumping tons of data from multiple workbooks. Here are some criterion I would like to meet: 1) I copied value and date(like 09/08/2016, Sep 8, 2016)...

Hi All, This is my first question. One of my work is using VBA to copy certain number and date from each binary workbooks (there are tons of workbooks) without opening them. And paste them into one worksheet from a new workbook in time order. How should I accomplish that? Thanks...

Hello. In Sheet2, Column B (B3:B50) I have a strings which I need to copy in Sheet1 , Row 3 in cells B3,D3,F3, ... V3 and X3 (12 in total). In Sheet2, Column G is so called "markers" Column because it contains markers/numbers for each product and those markers define copy position for each...

Good Morning, I need some help with a VBA code to get unique values from multiple columns pasted into a new sheet. I tried recording a macro but it got really messy so I thought one of you might have something easy to edit. Sheet one have over 7 pivot tables coming from different sources...