1. L

    VBA to copy rows where Date is greater than mentioned in cell

    I have a excel file with two sheets. Secon tab stored all previosu data and in the first tab I am adding new data every day. I need to comapre dates in column from 1st sheet and 2nd sheet and then copy from 1st tab only those lines where date is greater then in second tab (of course copy and...
  2. R

    Copy data on daily basis dynamically

    I have an excel sheet that contains all of my data named (Book1), and that excel sheet (Book1) updates on daily basis. What I want is to transfer the data for each date to another excel work book (Book2) on daily basis, without over writing the old data on the work book (Book2). For example if...
  3. I

    Mass Export Whatsapp chats to Excel

    Hi All I have recently used a VBA code, which works with selenium. The code allows you to use an excel spreadsheet to send messages via whatsapp, automatically. You may have seen the youtube video for the guy who wrote and offers the code, along with the spreadsheet: However I have vast...
  4. Jyggalag

    Have formula data appear as text, maybe VBA solution?

    Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...
  5. N

    Need advice about pasting sheets

    Hi guys, i really need your help! So I have many tabs of sales of products per week (so each tab is dedicated for sales of that week). It took me some time to manually calculate the sales of each product in that sheets. I was thinking to prepare the sheets for the upcoming week and prepare the...
  6. R

    Copying formats, then formulas down to dynamic last row not working

    What I'm attempting to do: copy all the rows from an open workbook, insert them into my other workbook that is a template, between to placeholders with formulas. my data in the template goes from A:CE. I've got the first part working where I insert the rows, but I don't know how to paste formats...
  7. P

    VBA Cut a row based off of the data in a cell and paste it into a table on another sheet.

    Hey! Hoping for some help once again. I have a table that tracks my rentals: Job Number: Job Name: Equipment rented: Employee: Company Rented from: Rental Start Date: Length of rental Estimated Due Date: Date Returned: Returned By: Total cost of the rental: Rental Complete Scissor...
  8. G

    VBA to Only Highlight cells with a Value

    Hello, I'm looking to edit this script such that if there is no value under the first row and then don't copy it. So only copy the cells with values inside Range("D11").Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select...
  9. M

    Conditional format not working when pasting values

    I have a sheet with various conditional formats, I have noticed sometimes when copying value only into the work sheet that sometimes the conditional formats work instantly and some times i have to click into the cell and click back out to get it to pop. is there something I can do to get them...
  10. E

    VBA code insert, copy and paste with formula and formats for the Number of rows given as input.

    : hi all, please help me in the below vba code, as beginner in the work sheet, just want to insert the multiple rows through input box and insert after which row through input box. then i make which row to be copied through input box. i cannot paste the copied row to the number of...
  11. 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...
  12. 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...
  13. 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 [...]...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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