sheet

  1. 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...
  2. G

    How to duplicate each row in every sheet number of times

    HI! I got a new problem. I have 10 sheets and 800 rows per sheet. I want to duplicate each row 1200 times in every sheet and I want do it on go. can anyone help me? P.S each row has a formula, format, and value.
  3. A

    message box in vba when range is less then.. vba in the sheet itself - view code

    How do I do the code in the sheet itself in the "view code" when the value in column K (any row in the column) is less than 10, a message will pop up to the screen that says - "10 days left until expiration" I would appreciate your assistance!
  4. vinzent

    Run Macro if all sheets are in the workbook

    Hello to all I have one macro, but I want to check if all the sheets in the file are in the workbook before to run (due we are using 10 different sheets with different names to get the information) and sometimes one sheet is missing to included before to run and only show error but we are...
  5. A

    how to copy cell value from one sheet to another with the same formatting

    hello, community. I'm trying for 2-3 days to make a Microsoft Access Database for a schedule at my work - 24/7 x6 people. it's too hard for me and I'm back to excel. at the moment I'm trying to bring the information (text) from sheet 2 to sheet 1 but i want to keep the text formatting ( only...
  6. P

    Find duplicates within a calendar Google Apps Script

    Hello all, I have the below code and I want if it possible to check if the event at the calendar already exists. If yes then dont make a duplicate event. If not create it. VBA Code: // Δημιουργία Μενού function onOpen(){ const ss = SpreadsheetApp.getActive(); const menuEntries = []...
  7. V

    Copying sheets from different files into a single file

    Hi, I am interested in a way to merge/copy sheets from multiple Excel files into a single Excel file. Some tool or script (python/java?) that will work in Unix and Windows systems, with/without MS Excel installed. While preserving existing cell format/style. Something equivalent to going over...
  8. C

    Border in different sheet

    How to apply border to different sheet after clicking on command button (active control) from different sheet? Here is the code i used Private Sub CommandButton1_Click() With Sheets("GraphReport") Dim LastRow As Long, LastCol As Long Cells.Borders.LineStyle = xlNone LastRow =...
  9. S

    Button Triggered Allow Edit Range with password with different password for each cells

    Was planning on making a button that utilizes the allow edit range feature which once clicked it will. 1. Lock all cells with value. 2. Cell with value will each have different password. and the password will be the Queue ID (Example - row 2 will only be editable if keyed in password T13P001...
  10. G

    Using VBA to scrape website betting odd data

    Hi, I would love for some help in writing some VBA code such that it will scrape data from a given URL for betting sites, and will return the specific betting odd values as required within a sheet. I then want it so that these values can always be refreshed as required. For example: Using...
  11. I

    Copying sheets but keep sheet references in formulas intact

    In my workbook, I have formulas on Sheet 2 that refences values on Sheet1. When I want to issue updates, my plan is to have an update button that among other things is to copy data from the wbUserCopy to the UpdatedWB. That process looks like this: If Not sheetExist(sSheet...
  12. J

    Runtime Error 9 Subscript out of Range

    Help! This is the most ridiculously big brained problem I've ever run into. I'm not sure where or when the problem came about, but all of a sudden I can't reference one of my sheets anymore! The only way I can get VBA to run any code that has to do with range references or object references to...
  13. Jyggalag

    Please help me create an IndexMatch-like formula

    Dear all, I am currently sitting with a rather large sheet of data. I have made a smaller, and more simple data sheet for simplicity's sake. Currently I have the following information: As you can see, the data for 2016 has already been filled out (through an old and more manual method)...
  14. C

    Print based on sheet names (dates)

    Hello looking for some support and not even sure if it is possible Am looking for a way to use macro to ask the user to enter 2 dates and it will print the sheets between these dates sounds simple but am guessing not as easy to do background Am using A single workbook with each sheet named...
  15. S

    Unable to copy or move sheet in Excel 2016

    Hello everyone!! i have this excel version when i try to make a duplicate sheet in workbook it showing like this, only 2 button are working that is View code and protect sheet: why other are not working??? please help me , i am worroy about this
  16. Y

    VBA to Hide/Unhide Sheets based on a table

    Hi, I have a master table with the following structure: Row 1 Column A (Item) Column B (Corresponding Sheet Name) Column C (To unhide corresponding sheet (based on IF statement results of other values in the table)) Row 2 Legal fee Legal Y Row 3 Admin fee for GHI GHI Admin Y Row 4...
  17. T

    VBA code for button on one sheet to filter table in another sheet

    Hello, I have two tables on two sheets in excel, the first asks the user to score a number of criteria in cells D5 to D107. The next sheet is a copy of this table (with the values of D5:D107 being copied from Sheet 1 to Sheet 2), but then has additional columns where the user needs to add more...
  18. J

    Auto-Create a monthly Sign in sheet for preschool students

    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but they start on different days depending on what month it is. For example: Next month, November 2020's first school day will be Monday the 2nd (11/2/20)...
  19. M

    How to fix a messed Excel sheet and make a proper format?

    I have a problem in a specific sheet: I need only country,network,NetworkName and currency columns, but in sheet all messed up. As you can see in network Colum there are name and MCCMNC code also same in network name Colum so basically I need to separate all data and make proper format by...
  20. M

    How to fix a messed Excel sheet and make a proper format?

    I have a problem in a specific sheet: I need only country,network,NetworkName and currency columns, but in sheet all messed up. As you can see in network Colum there are name and MCCMNC code also same in network name Colum so basically I need to separate all data and make proper format by...
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 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
Top