paste

  1. H

    Simply copy-paste(all) changes the font

    I am attempting one of the most absolute basic things in Excel -- copy a range of cells in one workbooks and paste them to another --- fonts, colors, values, formulas, EVERYTHING. Both files are .xlsx -- both sheets have the EXACT same font set for the entire sheet (Candara) -- yet every time...
  2. J

    Help modifying an existing macro to remove all of the "fixed" ranges in it

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

    Importing images from folders into corresponding cells in the worksheet

    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 [...]...
  4. Jyggalag

    Power Query question (never used before!)

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

    VBA How to round a value that is copied or a range that is being pasted ?

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

    Paste into filter column

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

    Copy sheet, values only, naming with today's date

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

    Macro to Copy a Specific Column Values From Different csv Files into a Single Worksheet

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

    Moving Columns - want to have a macro that finds certain ones

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

    Copying Range From Multiple Worksheets Pasting Into One

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

    Copy Paste VBA Question

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

    Macro to past based on columns

    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...
  13. Jaafar Tribak

    Worksheet_Change(ByVal Target As Range): How was the Target Range changed ?

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

    VBA: Copy cell and paste location changes via drop down menu

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

    VBA code to copy data based on criteria

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

    Macro to copy, paste, move. Rows to Columns

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

    Copy paste website source code

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

    Word Crash, paste fail and colour loss during VBA Macro when Pasting Image from Excel

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

    Copy elements from listbox

    hi, how do i select values from my listbox1 (after he gave me values ) copy and paste the value anywhere? my listbox result have 3 cols
  20. N

    Copy and Paste without deleting existing data

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

We've detected that you are using an adblocker.

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.
Go back
Back
Top