copy & paste vba

Hi All. This is VB embedded in Word but I am hoping you clever people can help me as you have done so many times before with my XL queries. My code pastes a number of sheets to a new doc and saves before emailing. The only prob I have is that it adds a blank page which is fine if emailing but...

I have 2 Columns (A & B) that I need to copy from excel and paste into word as RTF format. Although the number of rows differs daily, I will always need to begin the copy from cells A2 and B2. I am able to copy/paste everything into word just fine, but it selects too many rows when copying...

Hi there. I want to copy a sheet with a PivotTable on it to a new workbook, preserving the values and formatting of the sheet and PivotTable, but *without the actual PivotTable*. Something like copy/paste values + formatting of the sheet (including headers, footers, layout, etc.). Any...

Hi I have a workbook that I use for inventory tracking. I make a copy of the last worksheet almost every day and name it todays date. After some time the workbook becomes very large and slow to work with. I am therefore trying to create a macro that will move all previous months sheets to a new...

Hi, I have a very large amount of data in Sheet1, I want to copy all the rows where column "A" begins with "Sort By:" and this needs to be pasted in Sheet2 of the same workbook. The data will be around 8000 rows out of which about 3000 begins with "Sort By:". Its actually a paragraph in...

Two questions I first want to be able to copy that entire row that lookup value is associated in and copy where I currently have it going below. Second how do I input a cell 3 (col A) to the left of the copied cells which are in col D. The text that I want to be inputed is"ExtraActuals." Thanks...

Hi Guys I have this code: With mybook.Sheets("list") Set sourceRange = .Range("A1:b1000") End With Can anyone help me change it so that if it doesn't find sheet'List' it copies column 4 & 7 from table 1, and columns 4 & 7 from table 2...

A school I volunteer at has a number of workbooks that need to be updated. They basically need updated formulas, vlookup, etc. So, I have created a new template with all that stuff in the background. This forum has been so helpful in that work so far. Problem is, all the data, names, etc...

Good-day. I have 2 columns of data (D, E), each with multiple rows of data in (number of rows changes depending on task): 1st column (D) = base term (blue widgets) 2nd column (E) = Exact, Phrase or Broad (can you tell what I do for living!?) I need something that copies the value in column D...

Hi Experts, I'm using Excel 2007 on Windows XP. I have the following code that, a expert from Experts-Exchange provided, which takes an amount from one sheet, and based on the User's input, it populates that amount in a different worksheet in the same workbook. It populates it to an address...

New to VBA and Macros but am in need of one to perform a task. My goal: if a particular cell in one sheet has an x, then two cells from that same row are copied to a new space row in another sheet. More details: If space G3 contains an x I want cells E3 and F3 copied to a second sheet at cell...

Hello all: <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> I have a single excel 2007 workbook with eight worksheets and I wanted to find out if there was a way that I could automate that if data (text) were entered in a cell that this data (text) would...

I am using this code to copy from one sheet to another. They are both in the same workbook. lngLastRow = Cells(1, 1).End(xlDown).Row With Sheets("Datasheet") .Range("C1:F" & lngLastRow).Copy Destination:=Sheets("Sheet3").Range("A1") .Range("M1:N" & lngLastRow).Copy...

I am trying to write code that does the following: I need to loop through column E for any values that start with "DW" or "3". If a cell starts with "DW" or "3", I would like to copy a range (K:X) in one row beneath the found cell and copy it up one row (row in which "DW" or "3" was found). I...

Hi Guys, I have position sheet with several hundred positions and different metrics per position. Each position has its own row. To get a better overview over things I need to sort the rows based on different columns and I would prefer to do that in a separate sheet, so I retain the structure...

Hi all, I have searched the forums for an answer to this, but everyone wants to see to copy data from a closed workbook to an open one, not the other way around! I don't know if the last 2 links on http://www.erlandsendata.no/english/index.php?t=envbadac will help with what I need, so I better...

Hello, I have just written my first macro and I was wondering if i could get a little help. It's pretty messy and for sure not as efficient as possible but for the most part it does the trick. I recorded most of it and then modified it using helpful threads I found on this website. However, i...