copy paste code

Hi, I am trying to copy data from one workbook that is on specific location and then paste data to the another workbook and then save the 'another' workbook with specific name. I am able to save workbook but I am unable to copy data from one workbook to another. code gives an error. Below is...

Hi, I have data in two different sheets and one common column values...that is part# ...I have list of part numbers in sheet1 and based on each part number I have to filter the value in second sheet and copy the values (entire rows) and paste into different sheet that is sheet3. Plz note that...

Guys / Gals, Thanks your time & assistance: My group is putting "marks" in Excel (2007) work papers & sometimes they may want to add additional marks to those previously added in a selected cell. What I have below actually works, but I just got my VBA book last week & there has to be a better...

Hi everyone! I have a problem that I hope someone could help me with. I need VBA code that copies data from Sheet3 (Range A1:G3) and past them into different rows in Sheet1. Which rows the data should be pasted in is determined by cell values in Sheet3, Column I. e.g. Sheet3; Cell I1 says 10...

Hello Friends Could some one please check what is wrong with the following code; I am getting error message that script is out of range Workbooks(strSourceFile).Sheets("DataSheet").Range("A1:G1").Copy Workbooks(strFileName).Worksheets("Sheet1").Range("A1") strSourceFile and strFileName are...