copy and paste data

Hi Folks! I am grateful for the help I have received in my vlookup issue, but am now left with a new problem.... I have created the following sheet: ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAI12Oil Burner Repairs - Domestic (Beckett, Carlin, Wayne)345Ask About Our Service Partner Savings...

Hi, Please help. I am writing a code that need to copy from a "Source" workbook and paste to a new workbook (or "Target" workbook). So, basically I will have three workbooks involve; 1. Workbook where the VBA code is running 2. From the first workbook, I will add a "Target" workbook 3. Then, I...

Hi, I am using Excel 2010. I am attempting to write a macro that will open exactly 938 excel workbooks, copy the specified data, and then paste it into one master excel workbook. Most(99%) of the data in the 938 workbooks is in the same order. Once the relevant data is copied, I would like...

Hello, Currently I am trying to use Elseif statments to copy and paste information into a target cell from another cell on the same worksheet based on the value of the target cell. When I try to run my code, I recieve the following error message: 'Run-time error 1004: Application-based or...

Hello: I need help in completing a macro and incorporating it into some existing code that does function as designed. It's close to working but I haven't been able to get it right. The 1st part of the code adds a hyperlink (and it works properly) see below The 2nd part is the problem, I'm...

Hi All, I am facing an error while copy data from 3 files into 1 file. -- removed inline image --- { Microsoft Office Excel Cannot Create or Use the Data Range reference because its too complex. Try one or more of the following: -Use data that can be selected in one contiguous...

Having trouble with a macro that will search row k 12 sheets for a variable. Any time the variable matches I need it to copy to a seperate sheet. This is a monthly parts scrapping log and am trying to get running costs per dept. responsible

Hi All, Very new to macro etc and have mashed together bits and pieces to try and create the code that i need. I am nearly there but just need to tell it to repeat as needed. Here is the code I have so far: Option Explicit Public strSourceFldr As String Public EachFile As Object Public objFSO...