I named 4 different sections of cells as a range name,
specifically sheet 2 a1:a5, a10:a15 and a20:a25. named it "split"
I wanted to copy paste into same range on sheet 1 and named it "splittgt"
It gets all the way to paste then gives me this error.
"This action wont work on multiple...
Hi everyone,
I'm very new to VBA, so really hoping you guys can help with this. I have a very painful that I need to do every week and I am trying to automate it to some extent to try and save some time (and my sanity!).
I get a file from HR with the email address, name, title, and email+name...
Hi,
I have an excel file where employees can submit projects they are working on and amount spent on the project each month. The names of the months are therefore in the columns as headers. When I make a PivotTable out of the table I have the persons in the Row sections and the month I want to...
Can anyone tell me why this macro takes over a minute to execute?
Or perhaps offer an alternative way to do these commands?
Sub Clear()
'
' Clear Macro
'
Application.EnableEvents = False
'Move Stock
Range("NHKStock").Copy ThisWorkbook.Sheets("Lanes").Range("AI4")
'Move Leftmost Lane...
I'm not sure if it's even possible, but I need help in the following:
so far, I made a made to insert rows, by the value of D minus 1, each time column D is >1. The macro is working from bottom to top since its trickier for the macro to function if the last row keeps changing as its going top...
Hi,
I have a sheet in a workbook that displays results based on a drop-down list in that sheet. For example, if you choose "Site 1" from the list it will show the data pertaining to "Site 1" in that sheet.
There are about 100 different options (100 different Sites) in the drop-down list.
I am...
Hello All,
I'm making myself a task list, in this list i will have repeating tasks. Once the task is done (and dated) it needs to be done again (think how the laundry is in an never ending loop of despair).
I'm VERY new to VBA and despite a few days of google searching (which I, previous to...
Needing a macro that can copy cells on a line in columns B, C and D to a variable range in those same columns defined by the next line of the spreadsheet that has text in columns B, C and D and then repeat. I have tried a number of loops but failed miserably. I have attached images of what the...
Hello Gurus,
Do you have any thoughts on how to code this scenario (see image below)?
I was thinking of using Cell I2 in SHEET 1 as reference in order to pull the info from the different sheets (specific Data sheet and Others sheet).
Appreciate the thoughts. :)
I've been working on a report that I clean and collate using PowerQuery, and it's been fantastic.
However, I'm facing a slight issue when it comes to taking the output (which has been split into worksheets, with one worksheet for each work group) and creating a new workbook for each sheet. My...
Greetings, I would like your help to create a macro excel to track numbers and copy to next sheet. Here can you find the excel file with the data.
When we updated the data, we have to clear the rest of sheets, to copy new numbers.
https://www.dropbox.com/t/9aKMLs4JnMAUkZom
Hello can somebody help with the following problem please?
I'm trying to create a macro which I will then attach to a button.
Macro steps:
1. Select next available row after row 3 on 'sheet2'
2. Insert current time of day into column B on selected row
3. Copy cell C7 from 'sheet1' and paste...
Looking for a macro that will copy a range of data and paste it repeatedly into the next available columns 'x' number of times. The number of times will be specified on another worksheet, cell A1. In the example below, data was copied from range B1:C4 and pasted into D1:E4 and F1:G4, so 2 times...
Hi, I need help, please.
I saw a few options but nothing worked so far.
My problem is this:
I work with two sheets on the same file, "RawData" and "FinalData"
RawData is summarized data from PowerBI and it varies in the number of rows.
I added a column on that sheet with a condition, with Copy...
Hi.
I'm looking for advice on how to update my simple macro. I would like it to copy selected data from Sheet 1, and paste into the next empty row in Sheet 2, before deleting it from sheet 1.
Here's what I have so far:
Range("B2:F2").Select
Selection.Copy
Sheets("Sheet 2").Select...
Hello everyone, I am noticing a problem with my macro, but I can't find where I broke it.
The reason it broke is because I was trying to fix a problem where my macro deletes the =SOM formulas that were in the same column.
Here is an explanation of what my macro does:
My macro needs to copy...
Hello:
I am looking to create a macro that will be a ribbon button, that will copy values that have already been selected by the user, in either columns C,D or E and always paste them in column B. See table below for an example.
The user selects cells 1, 2 and 3 of data in col C and runs the...
Hi Everyone. I pull multiple reports from the same source and they are all built (same number of columns & same headers) identically. Only the data is different. Obviously I can copy them, go to the very bottom of the first workbook data, and paste in the first row. That was fine where there...
I’m creating a macro so I can click and drag down a formula X rows. The formula contains reference cells in another excel file that automatically increment. This is what I want. When I run the macro, the cells keep incrementing past what the original formula increments to. How do I repeat...
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.