copydata

Hi guys, I have this VBA to select cell B3,C3 and D3 which copies to a column N5, N6 and N7 I would like to know how to select any cell in column B plus including the 2 cells next to it like above and copy these to the columns N5, N6 and N7 Sub Cells() Dim CopyData As Range Dim cell As Range...

Hi, I have a scenario that I should copy the data from one workbook to another workbook, as per date, copy data from workbook 1(sheet1) to workbook 2 (Sheet1) workbook1: <tbody> date count 24/05/2018 2465 </tbody> from the above workbook it should copy the data of 24/05/2018 and...

I have set of records in sheet name as "Copydata" from c5 eg:- (UPE3-QUBBKHAB-1,UPE3-SENAJZAI-1,UPE3-109-00-303-1), here the records may be from c5 to c10 or ct to c7 or c5 to c3. I have another sheet as "List" were have all the records from c5 I am not sure, as will autofilter works with...

Hi im using the below VBA code, however in one of my staff's pc (XP, Office 2010) it shows this error msg 'METHOD OPEN OF OBJECT WORKBOOKS FAILED' Sub Copydata3() On Error GoTo ErrorChk ErrorChk: MsgBox Err.Description Application.ScreenUpdating = False Dim foundDate As Range Dim...

Hey, I am new-ish to excel and we are using it for our school coursework, I wish to create a macro which copies data (customer data) from one sheet into another. The first sheet would be a template called "New_Customer" and the second sheet would be called "All-Customers" The problem is that i...