copy

Hi all! Knocking out a huge project for work and I'm looking for anything to save time. I have successfully imported ~100 workbooks into a single workbook as sheets, labeled "3" to "103". From each of those ~100 sheets I'd like to copy the data in cells A11:Ax, C11:Cx, E11:Ex, and I11:Ix (from...

Hi Wanted to see why I can't properly paste an entire row on cells like a few weeks worth from online excel to a die loaded excel file The copy part isn't the issue only the paste part And I think the message I get is The data your pasting isn't the sane size as your selection. Do you want...

I have a large Excel data base of bacteria Genus'and i need to match the name in one worksheet, to another worksheet, copy that whole row, and paste into another worsksheet. Example... I have 3 worksheets A, B, C Worksheet A has 1000's of rows of names and many columns of data to each row...

I am very new to VBA. I have been trying to find the right VBA stuff to use to be able to copy over colors from another sheet. There are 6 different sheets in which I want to change the colors on the first sheet and want the designated cells in the next 5 sheets to change colors. I feel like I...

Hello everyone! I have made a sort of registry crm where one enters product code and quantity, excel returns name of product and price*quantity, plus it calculates start and end registry, loses, gains and other stuff. Some macros that clear specific cells and 2 more macros that: 1. user enters a...

For each row where there is text in column E, copy the entire row and insert it below the original row. Then remove the text in column E from the row that was copied.

Hi So, I have multiple workbooks (they are called: Human Resources, Science, Corporate Management, Public Affairs, .... I intend to add more). Each workbook has a sheet called: "Staffing-Processes". The data in each sheet has several rows (over 500 in some of them) I would like to be able to...

I want to search Column "b" for "98" and if found (could be multiples line) I want those lines to be cut and pasted in a new sheet called "Diesel Discount" This is what I got so far. If it Highlighs the first End With as error... Sub Move_Diesel_Discount() Dim LR As Long, i As Long With...

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

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

Hi All, 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...

Hey all, 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: B12 &...

Hello, 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") Else If Not...

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

Hi! I am trying to find an automated process in VBA for a very time-consuming task. This is my monthly table: column A Column B Column C Column D Store type How many stores? Type of file template New name of the file Store 1 4 1. 2023_Store 1_C1._feb.xlsx 2123 Store 1 Store 2 2...

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