copy

Hi All, I've been using this fantastic forum for previous VBA issues I've had, seeing other peoples posts and using the brilliant answers people have provided, however It seems Im going to need the extra help on this one! I have a workbook that I use as a report for Aged Debtors, with a query...

I have an "Input" spreadsheet with a list of unique values. Then I have a series of worksheets that are identical templates. I want to paste each unique value from the list on the "Input" sheet into the same cell within each of the separate worksheet templates. Is there a Marco / VBA code that...

I've got an inputs tab and 3 other worksheets in one wkbk. On my inputs tab, i've got cells I2:I14 that have column letters in it (A, AB, N, E, etc.) - these can be changed so they are variable. They correspond to the other worksheets within the wkbk. So 13 cells of columns to ID while...

Hello, I'll try and keep this simple. Sheet 1: Current 12 Months In column B, I have a list of employee IDs. As this is an absence tracker, each separate occasion of absence for each employee is added as a new row (so the same employee could have multiple rows). Sheet 2: Occasions Current 12...

I am looking for a VBA code/macros that does the following... Compare the data in a cell from Column A from Sheet 1 to the data in a cell in Column B in Sheet 2. If the data values are equal, then I want to take the values in the row from Column D in Sheet 1 and past them into the row in Column...

1. Open the file that has name, time and date 2. auto filter zero in a specific column "AL" and remove all the rows that has zero 3. disable auto-filter than save and close the file 4. copy the same file to another folder and paste it 5. delete the old file that is already there which is 30-45...

Hi, I am using the below code copying horizontally from one workbook and pasting vertically to another. but once pasting it's making a mess. Sub Alldrrdata() Dim sourceworkbook As Workbook Dim currentworkbook As Workbook Set currentworkbook = ThisWorkbook Set sourceworkbook =...

Hi, I have a VBA code (see below) for a macro button to add month sheets in a workbook. Now the month sheets are sorted from January to December, but I would like them to be sorted from December to January; while still keeping differently named sheets at the end of the worksheet tabs. After...

Hello, I need help with a makro in excel. I have got table1 in worksheet1 and on worksheet2 there is table2. Now, I want to select a certain value in table1, search for that value in table two and then copy the content below the found value and insert it under the selected value in table 1...

I'm trying to get better at this and in doing so, I've seen over and over again to stop using .Select and .Copy/.Cut to move things I know I can move my columns with copy and insert no issue, but I'd like to step into the next level. On one ws, i've got columns P to AB and need to move them to...

Hi to all. Got 1 problem(for now :eek:) cant figure it out. got row data on the left side (filled rows) if row (column A4) is not empty > copy row (formulas and conditions) F1 (from column BJ to GK) behind (after BI column) loop till last row. Would be grateful.

Hi! I would like some help, I'm trying to create a spreadsheet for moving items using macro in a table that has filters. I'm trying to use the macro to move products, "FROM" the initial position that the object is in (Cell C3), to "FOR" the final position that the object will be (Cell C5). I...

I have a data tab populating values for months running from Jan- Dec in Columns B-M. The current column is formula driven as it pulls values from a separate table/query in the spreadsheet that is filtered for the current month.. lets assume the current column is Column C (February)- “C2:C6” is...

Hi All, I want to copy my whole workbook (xlsm) with formulas and macros to a whole new excel file (xlsx) without any formula and macro. I've found the script below on internet and works fine but is for 1 certain sheet. How can i include multiple sheets and copy this to the new workbook? It is...

I have several workbook(.xlsx) that have only 1 sheet per workbook. I would like to loop through all the workbooks in the folder one by one and find certain cells with specific keywords and copy the cell adjacent to it. Next, copy all the cells and paste it in a master file into its respective...

I have a excel file with two sheets. Secon tab stored all previosu data and in the first tab I am adding new data every day. I need to comapre dates in column from 1st sheet and 2nd sheet and then copy from 1st tab only those lines where date is greater then in second tab (of course copy and...

I have an excel sheet that contains all of my data named (Book1), and that excel sheet (Book1) updates on daily basis. What I want is to transfer the data for each date to another excel work book (Book2) on daily basis, without over writing the old data on the work book (Book2). For example if...

Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...

Hi guys Hi guys, I need a VBA code which will be copy some files from Folder 1 to the Folder 2 . When I search in the internet i found some written solution but they are not exactly what I am looking for. I want to copy not the all ( B4:B12) files it will be for example only B6, in the next...

Hello, I've created (pieced it together from solutions found on this forum) a looped VBA code that currently makes a copy of all the non excluded sheets in the workbook, exports each sheet as a separate workbook, and saves them as a CSV file using the sheet name as the file name. However, the...