macro copy and paste

Hello Sir, I have daily routine work. I am creating bank position from Bank Statement. I have 2 files (1) Bank Statement (from Data Copy) (2) Bank Position (where data Paste) I would like to create a macro which is filter bank statement data. Select and Copy data from specify date &...

Hello Please can I have some help with a macro I am trying to create? I have a single row row of data in Workbook A, with the first column containing an ID number. In a Workbook B I have table full of data, where I want to add this row of data to. I'd like a button in Workbook A that will do...

Hello I am looking to create a macro that would allow me to copy from one cell and paste into another cell then go back to original copied cell and move down one record. For Example - Copy from R2 and Paste to C2 then Move back to R2 and move down one row to R3 Copy R3 and paste to C2, etc...

Hello Sir, I am trying to create a macro to copy and paste data from one Sheet to another sheet when Header and Column A data is matching and want to paste into the specific cell. below code is working fine for me when Row(headers) order is the same in both sheets. but I need a solution for...

Hi I have put together the following VBA code from a macro that I recorded. It works well, but I'm wondering if there's a quicker and better way of doing this: Sub Statement() Sheets("Statement").Select Range("C10:F41").Select Selection.ClearContents Range("C9").Select...

Hi Guys, Thanks in advance, I'm needing help with getting a VBA macro to lookup a field on change and copy that lookup information from another sheet. Ok so basically I have 2 sheets, 'Daily Report' and 'Exceptions' in the attached when the Yellow marked sections change then I need the macro to...

I'm trying to copy only the data in column "A" in a sheet named "Dups" into another sheet named "InvSummary" in cell "D7". I've tried to write and run a macro but cannot seem to get it to work. The data in column "A" starts in row 1 and could go 2 row or up to 1000. Any/All help is greatly...

Hi everyone, So I have a code that copies info from several identically structured downloaded worksheets onto a master sheet. However, I can't seem to edit the code properly so that I can add 4 more columns of info, in a specific order, to the master sheet . Im attaching the downloaded...