1. E

    Web Query limiting to 100 rows, nothing financial

    Hi! I just joined this forum out of desperation haha. I'm trying to link my Google Sheet to Excel Mac (latest version) and it limits the import to 100 rows, plus a message about "Finance Data Listing and Disclaimers." The Sheet I am trying to query has no formula related to anything financial...
  2. C

    VBA maco button for copying specific data

    Hello, I am very new to excel and VBA. I am trying to: -Have a button for each row in a sheet called "sheet one". -On click for one of these buttons, it copies 10 specific cells from the row (say J, H, I, M and L for a given row), -Putting them in a new entry in a different sheet "sheet two"...
  3. M

    VBA code to extract unique data across multiple sheets and multiple columns

    Hi everyone, I'm searching the web but I only found one code that kind of works but I need to make it more complex. Let me explain. My issue is that I have an Excel sheet with multiple worksheets, which all contain the same kind of information but are copied weekly by me. So every week, I will...
  4. Ephira

    Help with syntaxis

    Hi!, I´m new here I have a little macro. The problem is that i´m trying to copy a range of another sheet on the same sheet but i think that i have a error syntaxis cuz the macro don´t runs. These are the bad guys: Worksheets("plan").Range("G4:K7").Copy: Worksheets("plan").Range(Cells(j, 7)...
  5. 9

    How to find missing sheet

    Hi, I'm currently looking at this excel sheet which allows you to choose a project and prints the booking reference. I do not understand how the booking reference is found as it is received from a sheet called Data as shown, this is not installed on my system nor in any of the sheets in this...
  6. L

    Random Variable in a predetermined range

    Hello, I have an issue, I need to: Ask the user for the highest and lowest possible values of the random numbers Ask the user how many rows and how many columns she/he wants to create Insert a new sheet into the workbook with the name "‘RandomNumbers"’ and fill this sheet with the appropriate...
  7. J

    Add sheets to array and select

    Hello All, I got 5 sheets with different tabcolors. The tab of a sheet becomes red when a certain value on the sheet isn't met. When it is, it becomes green. The only sheets I want to select as an array are the green sheets. How can I do this? For example: Sheet 1 tab color = Green Sheet 2 tab...
  8. H

    Help needed! Google Sheets count dates from last month?

    Dear Everyone! I want to ask your help. I have read all about this forum, but the solutions i've found, not work for me in google sheets. My wife leads a Development Centre that helps little children to develop motor skills. At the beginning of a new month, she has to send a report to the...
  9. E

    How many surveys needed to reach the target percentage?

    EMPLOYEE NAME SURVEYS POSITIVE SURVEYS NEGATIVE SURVEYS CURRENT PERCENTAGE TARGET PERCENTAGE POSITIVE SURVEYS NEEDED E1 42 50% 75% If positive surveys vs negative surveys count as 9 positive surveys is equal to or gets canceled by 1 negative survey. With the given data above, how many...
  10. J

    Pulling data from cell to fill in a link

    Hello guys! Firstly, feel free to save time and jump straight to the TLDR bold section below, then read the rest of this long post only if more context is needed to help. This is probably a super easy problem for most of you, so trying to respect your time here, but also include context incase...
  11. W

    SUMIF for all sheets between 2 specified sheets

    I am new to spreadsheets and have no training. My knowledge is very limited. Screenshots of the spreadsheet I’m creating are attached. I am attempting to total all miles and fuel by state on sheet “Quarterly IFTA Report” for all the sheets between the sheets “Start” and “Stop” Additional sheets...
  12. G

    Excel/Sheets - ISO Solution

    Hello all, I'm trying to improve the inventory management process at work, currently we're tracking everything through manual input (handwritten) using a form and then we put any relevant information on a sticky note and post it to the box. These boxes come in from numerous different places and...
  13. A

    Take a value from the same row where it finds a coincidence in other sheet

    Hi! Im new on excel and i have no idea on how to use it at all. I wanted to search between two sheets, which I managed to do, but then I would like to search on the second sheet, 'C' column every coincidence with the H2 field on the first sheet. Every time it finds one coincidende (so for...
  14. A

    Can you create "Sub Sheets" within a sheet in excel?

    For example, I have a workbook I use to enter data from my daily work deposits. Each sheet n the workbook has a single days worth of data. We run on a period schedule of 4 weeks. I would like to be able to create a sheet called "Period 1" and hide all of the date sheets within the specified...
  15. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  16. K

    I need to copy specific information across several sheets in one workbook into one sheet in a seprate workbook

    Hello, I am trying to rebuild and hopefully automate a very manual report that pulls specific sets of data that's housed in several different sheets in one workbook, onto a corresponding community sheet in a separate workbook. The community data I need is currently pulled by one report and...
  17. O

    A problem about "information transfer between sheets".

    Hi everyone! Let's say there is information on Sheet1 consisting of 3 columns. When I write one of the information in the third column in a cell on Sheet2, I want the other two data in the row of the information to be printed. I would be glad if you help. ex: Get the name, age and citizenship...
  18. K

    Possible to pull data from a website to show count of unread faxes?

    Hello, I am looking to see if it is possible to pull data into google sheets (or excel) directly from a website to show a live count of how many unread items there are. This is for a business where we receive faxes through a system called SRFax. My best guess for something like this would be...
  19. H

    How do you unhide multiple sheets?

    I hid a lot of sheets, now I seem tho have to unhide them one by one. Is there a btter way?
  20. F

    Help Needed Combining Index/Match with Sum across Different Sheets!

    Hi All, this is my first time posting here. I have done a lot of google searching but i haven't found exactly the problem to my issue. I have multiple sheets which i want to add across. the rows and columns are not in the same order, therefore, a simple sum across sheets wont work. I want to...
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