copy paste

Hi Experts, I have a little problem, i think you may have a solution for me as always i got a solution from this forum. Here is the picture: I am trying to copy text from first Table Heading "FRUMENTO TENERO NAZ.LE (1)". When i try to copy only this table text the next table text also...

Hello, I am trying to copy about 100 formulas from a row, and then paste them 2 rows below where I copied, and then have it filldown til the last row.The issue is that the 100 formulas are not in the immediate columns, it can go A4 - F4, and then M4-N4, P4-T4... and so on. Here is what I have...

While using conditional formatting in XL 2010, I am facing this problem. ( I am stating a simple similar scenario, which has the same issue occuring) I wish to highlight a cell, if it is not a blank. I have entered a simple conditional formula =$A13<>"" -- with a format color. I now wish to...

Hello all! Quick question about Pivot Tables and their layouts. I have data in a pivot arranged in rows with the Employee name, followed by the hour of day (a filter trick we had to use) then an activity. So the format looks like this Employee Name Hour of Day Activity...

Hi, I am completely new to macros. Need a macro that would do the following: 1. copy-paste from multiple workbooks (all in one folder) into one Master workbook. 2. The first sheet in each workbook should be pasted on separate tabs in the master workbook 3. It should always paste from the...

I have a sheet made into a form with some check boxes included. If I select all the relevant columns, create a new sheet, and paste into cell A1 - all of the information carries over just fine. You can still select cells and check the boxes in the new sheet. However, when I record this action...

Hi, I have a macro that starts with an inputbox. It asks "how many samples would you like to add?" From the value that is input, I would like to copy a range of rows (that is already on my template) and paste as many times as the inputbox value states . My Macro has started as InputNum=...

Hi, I have 15 worksheets with 1,000 rows of data on each worksheet. Every row has 5-6 columns. I'm using a third party plug-in to automatically update the 1,000 rows - this takes roughly 3.5 - 4.0 mins. Once the newer data is available, the older data is lost and is replaced by the newer data...

I am trying to copy and paste the value of a certain cell (D16) onto another sheet. This value changes every hour. I have the below code but I am getting an error message at frng.Offset(1,0).PasteSpecial (xlPasteValues). Its telling me Run-time error '91': Object variable or With Block variable...

Hiho, how you doin? I've been working in this code these days and can't get it working. Excel keeps showing this message: Run-time error '-2147188160 (80048240)': Method 'PasteSpecial' of objects 'Shapes' failed Here it goes the code i've been working so far: Sub CopyToPPT() Dim PPApp As...

Tying code to a quick toolbar button to expedite a repetitive task of always copying the same columns from an export file into my main parts data file as follows: Starting w/ ROW 3 in filename: "exportParts.xls" (it will ALWAYS be this file name) Select B3 down until end of data and PASTE into...

Hi Everyone, I'm looking for one assistant....I have folder which contains 100+ PDF files and these file names I have it in my excel say it start from A2 cell... I would like to move PDF files to different folder based on PDF file name which is there in the excel sheet.... For Example: If A2...

Hi, I have an excel sheet with certain cells protected which I sent out to various branches/divisions to complete. They could only complete the unprotected cells. Now I want to copy these sheets all into one workbook. This workbook should have separate tabs for each of the divisions sheets...

I have 2 tables that I use to do VLookup's. One table uses a truncated version of the item name. Is there an easy way to have excel copy the full name and then paste an edited (truncated) version so my 2 tables match?

Hi all, I am new at Macros. I just need a little help on automating a process that I usually do manually. I am sure its a very simple macro but any help will be appreciated. I would like the macro to check if column AB=1 or 2, on "Sheet1" then copy the whole row for that column and paste...

Hi Will appreciate any help in this I have one sheet where in one range (say D23: D200) computes the cash flow ( which could be negative or positive ) . I need to do this 1. Read the value in cell D 23 and if its negative then 2. Copy it 3. Do a paste special in cell F 23 with change of...

Hi All, I am having much difficulty transposing a large data set. The result I am after seems simple but is proving to be somewhat difficult. I have a list of the following data. <tbody> Account1 a b c </tbody> <tbody> Account2 d e f </tbody> <tbody> Account3 g h i...

Hi I have data in Excel like below in excel sheet Need To copy and Paste each ROW Need to Paste Each ROW in new sheet1,sheet2,sheet3. one by one. A B C D E 1 Sri 89 H6 YES No 2 Pri 90 K1 No Yes 3 Lio 87 G5 No Yes Need...

Basicly I have to copy formula from left to right. Certain ranges contains values and formulas, let say as example (even there are many similar ranges, that is way I need VBA): Range: A2:C10Column A is totaly values, which is OK Column B currently has only values (this is subject of my wanted...

I'm trying to teach myself VBA from books and examples so please excuse the elementary level of this question but all i'm trying to do is copy one range from one place to another place in the same sheet. so i wrote this... Sub timepaste() Dim myrange As Range Set myrange = Range("c2:c5")...