copy

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

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

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

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

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

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")...

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

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

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

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

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

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

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

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

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

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

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

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

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

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