I have taken over a project that someone previously developed the macros for. I would prefer it to work regardless of the dataset being used, but the person that developed it used mostly "fixed" ranges and I would prefer that it determines the range based on the data set.
The beginning of the...
Hello.
I need a macro that I have no idea how to even start making.
I have multiple images in multiple subfolders. The file structure looks like this:
/Excel_file.xlsm
/Images/Object1/Image1-1.jpg
/Images/Object1/Image1-2.jpg
[...]
/Images/Object2/Image2-1.jpg
/Images/Object2/Image2-2.jpg
[...]...
Hi all,
I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query.
I want to import data into this pivot table (not using power query below):
I have the source data saved here:
So questionnaire data file 1 is week...
Good day,
Looking for a way to round a value I am trying to copy or the range I am trying to paste.
The code is below. Tried inserting Round., but do not seem to find the correct placement. Also tried numberFormat = "0.0".
Could round the whole column after pasting in the values, but would...
I am looking to post a range from one spreadsheet into another which has hidden rows due to filtering and i would like to ignore these rows.
for example, this would be the range.
A1122334455667788991010
And i would like it to paste here
A112288991010
but as you can see, it is filling in the...
I am trying to copy an entire sheet, pasting only the values and renaming the new sheet to the current date.
This code allows me to input the date manually, but it copies formatting and the formulas too.
Sub AddNameNewSheet1()
Dim Newname As String
Newname = InputBox("Name for new...
Good day experts, I need to fetch values from an identified column (DistanceToNext), across numerous csv files into a single worksheet. These csv files are indexed with numbers. The first csv file indexed 001 is to be pasted in first column of the single worksheet. The second csv indexed 002 to...
Hi all!
I want to create a macro that will find a certain column, based on the value of a cell in that column, and copy/paste values the data from that column to another sheet.
The reason why i need it to find based on a value of a cell is because i have "customizable"/"moving" columns and...
Can someone please help me copy a specific range from multiple worksheet and paste it into one worksheet? The worksheets are formatted identically. I need the ranges B11:B24 and C11:C24 of each worksheet to be pasted on a new worksheet. Also, I need D5 of each worksheet to replace C11 in the new...
Good day,
I currently have the following code and I'm trying to find an quicker way to copy / paste it.
Sheets(1).Range("A2:B2").Copy
Sheet1.Range("$B$2").PasteSpecial xlPasteValues
Sheets(1).Range("F2:G2").Copy
Sheet1.Range("$G$2").PasteSpecial...
Hi all,
Tried looking around for this one but can't find something that works.
I have data in columns A - D that a macro pre-populates, only column B has data in every cell. The macro copies a date from one sheet but what I want it to do is find the first empty cell in column E to start...
Hi all,
Worksheet_Change(ByVal Target As Range)
The worksheet change event tells us which Range (Target) was edited but doesn't tell us how.
As we know, the user can change a cell either, by editing it with the keyboard, by pasting a value into it ,by drag and drop or by using the autofill...
Hi All,
I have a data analysis sheet that Im currently working on. I have a drop down list with different entries and I want my code to a copy specific cells (C102:G105) and depending on the drop down menu selection change the paste location of cell in different sheet. I have some of the code...
Hi There,
I am looking for a VBA code that can copy all the rows (Incl Headers) based on criteria in specific column.
Scenario :-
I have a File with 8 different sheets and different information. Commonly, every sheet has a "Status" column.
I want to filter the status column and check for...
Hi everyone,
I have a list of data which is all in one column, essentially I am trying to create a macro or formula that will move all the text from the column into the correct row. Row 2 shows how the data should look. Essentially I am trying to convert all of the data currently in column A...
I copy website source code and paste it to excel just ctrl-c, ctrl-v. It paste fine and there aren't any website rendering, just plain text as source code is. There are about 800 rows. But pasting is slow. It takes about 5 seconds to paste. I have no macros running and tried also calculation in...
This code is driving me insane. I have created a macro that is structured as below. It creates a chart based, copies it from an Excel Chart tab and pastespecials it into word. Creates a page break, clears the clipboard and does it again for a total of around 100 times. Please see the below...
Hello All,
I'm looking to copy the data cells A28:N46 through to the range of A58:N106 with a button click macro without deleting any data that had previously been put into the range of A58:N106.
+ I would also love to be able to then clear contents on the data that was copied if possible.
So...
I am in VBA H**L right now.
Here is what I need the Search Loop to do.
In Column A cell "A2" is a changing value depending on the person selected. This is basically a RecordId column.
Starring In Column H cell "H2:JZ2" are changing values. These values could be nothing (empty), or contain...
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.