I have this problem. I want to create another workbook and paste the values of specific starting cell and select down to the end. Then, I want to copy the values starting at cell AP41.
the sample output was shown in the picture output1. in my source file, I have 100 sheets, I want to loop on the...
Let's say I have 2 workbooks and i have to create 1
wb1 = workbook with the macro
wb2 = worbook with the info
so I have an activeX button in wb1, when I click it it should copy the KeySheet from wb2, create a new workbook (wb3) and paste the sheet onto this new workbook
Idk if i explained...
I have two spreadsheets named New.xlsx and Old.xlsx. I'm looking for a VBA code that compare each column T values (unique ID) in New.xlsx with values in column T (unique ID) in Old.xlsx. When there is a match, it then copy the value and cell format (e.g. cell color) of the cell in column...
Sorry if that isn't very clear. What I have is a spreadsheet where I have a MAIN LOG, which I use to keep track of client appointment and report timescales. That all works fine, so don't worry too much about that. What I need help with is this. When 'Y' is entered in Column R (indicating...
I have a problem and have NO idea how to solve it - it is about a dynamic sheet that should show a timeline (Calendar weeks) and quantities in that timeline. Attached is an sample workbook with all information -> 20230522_SAMLE_WORKBOOK.xlsx
But here are additional information:
When I copy from a Excel sheet data into Word it rounds the numbers behind the . I think all this is because of all the different cell formats all the columns have. Is there a way to copy and paste the data with all the numbers behind the . like 12.03767 ? After copying in Word this is...
Hi to all
I need some help to change the code that I use to copy value...
This code I use:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
If Not Intersect(Target, Range("B2")) Is Nothing Then
Set rng = Range("C2")
rng.Value = Range("A2")
I've got an issue with FIleCopy command in VBA. I always used this when i wanted to copy/paste some file from one folder to another. (but it was local or based on the server).
Unfortunately at that moment i have to wokr with onedrive solution. I need to build some file (or rather wanna...
I have a range ("A31:AB31") in the "Input incidents" sheet, so I need to paste it (only values, no formulas) at the next available row in a data base ("Incidents_Accu"),
the columns are also A:AB in the data base, the information should be accumulated in the data base by clicking on an ActiveX...
I need to find certain columns based on header name in 1 sheet and copy them to another. My code works for "Task Type" and "User". However it does not copy the other columns. I tried using 2 words and it worked. For ex. Instead of "User Email Address", I changed the column header and array to...
I am trying to find an automated process in VBA for a very time-consuming task. This is my monthly table:
How many stores?
Type of file template
New name of the file
1. 2023_Store 1_C1._feb.xlsx
2123 Store 1
I am probably doing something wrong but I keep getting an error and I dont know how to fix it.
The long and the short of it is I have to copy data between three different excel workbooks
Dim wb1 As Workbook
Dim wb2 As Workbook
Dim wb3 As Workbook
Set wb1 = ActiveWorkbook
Set wb2 =...
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!:
Paste(Special) ranges InvPrint!:
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")...
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...
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...