copy

  1. S

    Copy and paste one row from filtered table as new a new row, always in row 3, to protected worksheet

    I have a protected spreadsheet of "high volume" users of the Emergency Room. These folks have many visits throughout the year. I need the user to be able to filter existing records by selecting a previous. patient. the filtered data returned should be sorted by patient name and most recent...
  2. D

    Trying to make a form that will auto update values on different sheet

    I'm trying to out do myself, I have a basic form built out with drop downs and blanks. So far i have formulas in place that will find an "Available" ip by using xlookup, and i also have an xlook up to find the row, column and sheet name, i have a cell formulated to show a complete location (ex...
  3. Agnarr

    Type a code in a cell and have it replaced with a given name.

    Hello everybody and you all do an amazing work. I need your help please and i apologize in advance for any mistakes (English is not my native language). I have an excel where I need to type a 4 digit code in a cell and when after pressing enter, I need it to be replaced by a name corresponding...
  4. M

    I would like to make a macro that loops down a pivot table slicer list and create separate sheets based on data from each slicer selection.

    So I have a sheet that has a pivot table in the "Pivot Table Reference" tab, that has a slicer called reviewee name. Based on what is selected on that slicer that pivot table is referenced in a sheet on the "Output Sheet" tab. What I need is some kind of a VBA cycle code that can automatically...
  5. J

    VBA Copy/Paste

    I'm looking to copy/paste within the same macro, using 2 different methods, ActiveSheet.Paste and Selection.PasteSpecial. Scenario: Row 1 has a series of cells that I'd like to duplicate to rows 2, 3, 4, etc. However some cells (call it A1) has a formula in it that I'd like to only copy the...
  6. J

    Copy Multiple Ranges Paste to Designated Ranges

    Copy ranges Accounting!: AY13:BH13 AL15:BH15 Paste(Special) ranges InvPrint!: AT6:AY6 D20:AJ20 This is as far as I got regarding the code... Dim Rng1 As String Dim Rng2 As String Dim Rng11 As Sting Dim Rng22 As String Rng1 = Range("Accounting!AL15:BH15") Rng2 = Range("Accounting!AY13:BH13")...
  7. K

    Folder contents Empty

    Hi, I've written a VBA to copy files from a list of directory over to a specific folder. The code works fine and what I now need to do is add an IF statement for the VBA to move to the next folder when one folder is empty and copy any files in the next folder. Any codes that will allow the VBA...
  8. M

    Get Data From Sheets to MasterSheet and keep All sheets updated if Something is updated

    Hey Guys, i have an Workbook with 5 Sheets where you can add Data while Using a Userform. The Data begins in each Sheet in row 10, since i nead the rows above 10 for my interface. I have also an Mastersheet, where the Data from these specific Sheets should be copied and should be edited if...
  9. B

    Copy and paste x times with a y Size

    Hello im trying to copy and paste a variable number of columns a variable number of times. I can get it to resize a variable amount of times but not if i want to do a variable amount of rows as well. this is my code: Sub getRng() Dim Cval As Variant Dim Rng1 As Range Cval =...
  10. O

    copy and past data from specific cells from multiple workbooks to master workbook (but need to copy the cell even if it is empty)

    Hello , i need to make the bellow code copy even blank cell (to avoid input data from 2 workbooks in the same row), because the final output is going to be storing the data from each workbook to a single row . Sub Copy_specific_Cells_From_other_workbooks_auto_RF() Dim FileName$, sPath$ Dim...
  11. U

    Copy Paste Formula adding extra rows

    Hi there I have a sheet "invoice template" which contains 6 rows per 'invoice'. Each invoice pulls the reference and the container number from the second sheet ("jobs") This works in the first 6 rows reference is =jobs!A2,and container is =jobs!B2 However when I copy those 6 rows in...
  12. T

    Defaulting to Manually (not via VBA) Copying Visible Cells Only when Source Range has Auto-Filter Applied

    In my employer's Microsoft Excel for Microsoft 365 MSO (Version 2206 Build 16.0.15330.20260) 64-bit), I created new dummy workbook, and it defaults to copying visible cells only when I copied an auto-filtered range despite: a) common sense (i.e. why have a (Alt+)"Home", "Find & Select" (FD), "Go...
  13. R

    Adding additional information to every nth row from start reference, copying same instance of rows

    I've got code here that will bring in information while looping through workbooks in a folder. It could be 5 workbooks or 50. Usually on the higher end. I'm bringing in 5 rows of information so every time i open a new workbook for information, i need it to go down to the 5th row and start again...
  14. R

    Prevent changes to specific worksheet (VBA)

    Hi, I would like to disable the option to delete, move, copy or rename one specific worksheet in a workbook, regardless of the activated worksheet in the workbook. I cannot protect the workbook structure, because I want to still be able to delete other worksheets in this workbook without the use...
  15. M

    Copy and paste to blank cells only

    Hi, Have a peculiar problem in excel that I am trying to solve. I have data in an excel sheet under columns A through E (including column headers). I want to paste this data in another excel sheet. However, while pasting, I want to past the data only if associated cell in other sheet is...
  16. T

    Use excel as a clipboard

    I have a feeling this may require something other than just excel, but no idea what. I would like that when I [highlight>> right click >> copy] a word it is automatically added to a cell in excel. Essentially using excel as a clipboard with a new cell for each copied piece of information...
  17. C

    Copy Worksheets that start with xxx to a new Workbook using a variable for the Workbook name

    I am trying to copy worksheets within a workbook to new workbooks based on the value of the sheet name. So there could be any number of worksheets in the file, say 5 sheets start with the name Allegiance, 2 start with Express, and 3 start with McCollum. I want to copy, either a sheet at a time...
  18. P

    vba code for filling out just copied excel file with info from another workbook

    Hi All, I am looking for a code that will help me copy a workbook and fill it with information from another workbook. i already wrote a code that creates a copy, now i need a code that it will take information from the source workbook put them into the workbook i just copied, i hope i have...
  19. A

    Excel VBA: Loop through autofilter criteria to copy and paste to new sheet then save as new file.

    Hi all, I want to loop through autofilter criteria in column G( below photo) to copy and paste to new sheet then save as new file. Below is my code, i know that it can use if and else to do, i want to know how to change to use the loop. Thank you very much for your help. Dim wb As Workbook...
  20. R

    Copy error - range is cutting and pasting to wrong sheet

    My code below: Sub arrange() 'all declarations for wkshts and wbs stated at top unless stated here Dim g1 As Range Dim g2 As Range Dim g3 As Range Dim g4 As Range Dim g5 As Range Dim g6 As Range Dim g7 As Range Dim g8 As Range Dim g9 As Range Dim g10 As Range Dim g11 As Range Dim g12 As Range...

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