copy & paste array

I named 4 different sections of cells as a range name, specifically sheet 2 a1:a5, a10:a15 and a20:a25. named it "split" I wanted to copy paste into same range on sheet 1 and named it "splittgt" It gets all the way to paste then gives me this error. "This action wont work on multiple...

Hi internet peeps. I am stuck i don't know what code to use so i can search the same column twice for 2 different keyword and then copy data from the same row to another spreadsheet in sequence from a start cell. for details here's what i am trying to do 1. Limit the search within a range of...

I got data in sheet1 and sheet2, which i want to copy and paste in sheet3. That is already done. So next i want to match rows, by checking column C, D, E, H and I. The C and H column value is integer and the rest is text/strings. If two rows match, then i want to copy and paste one of the lines...

So I have certain formulas (in range) in one excel file, and I need to copy-paste them into other excel files grouped in folders. I wonder if it is possible to do it with VB coding or any other methods ? Formula range is simple and looks something like this: <tbody> =A6 =I9 =AZ3 =O12 =L1...

Hi Team, I am looking for some help in copy and paste the data based on some criteria. For example, I have 175 columns in sheet2 and this might increase or decrease. I have 25 columns in sheet1 this may increase or decrease based on the requirement and all these columns has the same names (99%...

Hi Community I would like to explore the possibility of copying data from different workbooks to a Master sheet. Based on some of the threads, i have tried the following code: Sub CopyRange() Application.ScreenUpdating = False Dim wkbDest As Workbook Dim wkbSource As Workbook...

Hi all, new to VBA so please be gentle. I have created my first piece of coding and need to amend it slightly but not sure how. Basically I am wanting to copy data from sheet 1 (Sales) and paste to either sheet 2 (RM DOM) or sheet 3 (RM IND) based on two IF statements. If column B in sheet...

Hi Guru's I have a question. I have 10 Tabs. Each with 2,387 Rows with Columns A:BW. I want to merge all those tabs into One separate tab. I only need to extract Columns A:F; I-U;W-AH and all the rows. How do I set this up? I would guess it would be something like For each pnlTAB in...

All, I am trying to write a macro within a central model (let's call this the 'aggregator model') to open a series of spreadsheets (one at a time), then copy data and paste as hardcoded values into the central model. The main difficulty I can see, is identifying the area where the data should...

I am trying to copy data from one worksheet to another using VBA. This is the code I currently have: Sub sbCopyRangeToAnotherSheet() Sheets("Active Worksheet, A2").Range("Q1:S52").Copy Destination:=Sheets("Analyst").Range("B3") End Sub I am trying to link the sheet name in my VBA code to the...

Hi, i am very new at Vba. I not sure I can even do this. I've tried in a macro but it didn't work. I have a file there are multiple sheets included. One sheet contains a list of employees - that are listed in rows. There are 200+ tabs (5 to exclude), each sheet named with the employee...

The workbook that I am starting in is called "Rachael" The workbook that I am trying to copy into is called "Jessica" This workbook has two tabs that I need to paste into “Summary” and “Summary Fall” The range that I need to copy the information into is: X 8:61 - "Summary"...

Hi, I am new to VBA and am trying to write what is probably a relatively basic macro. I have one column labeled Data in the first row, with data in the rows following. I have another column labeled Data2 and I am simply trying to copy the data from the Data column (not including the "Data"...

Hi All, Looking for a bit of guidance re: the above. I have inherited rather ungainly couple of data tables (let's call them 'Original' & 'Revised') and am working on an easier way for changes to be made or modeled On a separate worksheet ('Changes') I have done all the leg-work in terms of...