copy

  1. A

    Copy values of a list one by one to multiple worksheets

    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...
  2. R

    Creating a variable list of columns and ranges to copy to another sheet based off values in cells

    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...
  3. Chris_010101

    Copy unique values

    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...
  4. S

    Compare and Copy Data from Columns in One Sheet to Another Sheet

    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...
  5. R

    Search copy paste delete the workbook with date time in the name

    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...
  6. B

    Copying Horizontallyand Pasting Vertically

    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 =...
  7. R

    Macro to add month sheets containing days

    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...
  8. M

    Makro to find selected value in another sheet, copy rows under found value and paste below previously selected cell

    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...
  9. R

    Copy multiple columns to end of range without using .Copy or .Cut

    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...
  10. KoskeKos

    VBA loop copy formulas and conditions based on rows

    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.
  11. L

    How to use Macro in a worksheet with filters? To move items

    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...
  12. F

    VBA Copy Paste column to next blank column

    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...
  13. R

    Copy all sheets to new workbook without formulas and macros

    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...
  14. A

    VBA macro to loop through all workbook > find keywords in cell > copy adjacent cell > paste it in a master file into respective header

    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...
  15. L

    VBA to copy rows where Date is greater than mentioned in cell

    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...
  16. R

    Copy data on daily basis dynamically

    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...
  17. Jyggalag

    Have formula data appear as text, maybe VBA solution?

    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...
  18. T

    Copy file with VBA

    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...
  19. J

    VBA script adding "" to CSV file

    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...
  20. R

    Format copying not working

    This is my full code Sub StripData() Call InsertData Call FormatData 'Call DragData End Sub Sub InsertData() Dim myWb As Workbook Dim myRowsToCopy As Range Set wbtemplate = Workbooks("Template.xlsm").Worksheets("Raw") Set formatrange = Range("B2:CE2") Set formularange = Range("AK2:CE2")...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top