remember

  1. C

    Grouping Rows

    Hi all, I want to group rows in blocks of 2 rows at a time. For example...row 1 & 2 would be a group. row 3 & 4 would be a group. so on and so forth. I want to use the 1 & 2 button to open and collapse the groups. I had it before but can't for the life of me remember how to do it again. I have...
  2. T

    VBA to create pdf thats 2007 compatable

    Hi Everyone, I need a macro to create a pdf of active sheet but it needs to work on 2007 version as well anyone remember the code to do this? please help if you can Thanks Tony
  3. S

    Link Multiple Slicers (into one)

    My slicers are using different tabs for sources, so they won't link in the report connection. I once created a massive slicer that would edit any slicers you attached to it without using the report connection feature. Although, for the life of me, I cannot remember how I did this. Any...
  4. A

    Remove Columns

    One of my worksheets stops at column "Z" and there's nothing to the right of it. How did I do this ? Can't remember and can't find how from Google. Thanks.
  5. T

    Formulas showing a value instead of a blank cell

    I am doing a vlookup from a different workbook and in the cell where the formula is, some of the cells are "blank" and others have a "0" in them......... I don't remember how to make is so the cell is blank if the value from the vlookup is 0 or NULL. Thanks in advance...
  6. C

    Quick Formulae help...

    Hi all, What I am looking for is a quick VBA solution for this issue. When the sheet "opens" I would like it to search row 3 in the spreadsheet and match the dates in those cells to the current date and move the cursor there. I can't for the life of me remember and when a friend wakes you...
  7. G

    Drop down list returning another list element

    Hi guys, I deal with a lot of weird identifiers that I can never remember and I was wondering if it would be possible to create a dropdown list that returns an element from an adjacent list. So if you refer to the list below as an example, let's say my drop-down list would be counterparty...
  8. N

    Formula for 4 sheets

    Hi, Is it possible that a formula in a workbook work separately for 4 sheets in the same workbook? All you have to remember is that the answer comes out from the same cell of the formula. Thanks in advance
  9. M

    keep a record?

    hello i wonder if any of you could help me i need a formula in a cell that can "remember" or "keep a record" and sum the values that changes in other cell example <tbody> 1 1 </tbody> then <tbody> 2 3 </tbody> then <tbody> 0 3...
  10. I

    Can’t remember the code to use

    I have a specific cell which is J9 I have a spreadsheet of user information. Now I cant remember the name of the code to use but when a name is entered into cell J9 this code would then look at the spreadsheet in column D for the same name & select its cell. Thanks.
  11. D

    Combine Worksheets into One

    I have another one for you. I have an inventory sheet I get from a vendor every week. All I need are the columns: Product Code QTY in Stock I would love for them to pull from all 5 sheets and make them one long list. I can't remember how do to that in PowerQuery. I get an updated inventory...
  12. H

    help with code within Excel

    I would like to know where I can get help within the VBA module, If I cannot remember some of the VBA code names
  13. C

    Is there a way to convert thousands of old word docs 98 to say 2010 automatically?

    Hi guys, I had an old program which look in folders and converting word from say 93 to 2010, and then deleted the old files. When I open Word it was in the Add in. When it was finished it printed a page of all the files it had converted Then they had a computer upgrade and all my old programs...
  14. T

    Calculating a percentage and then rounding it up.

    Hello, newbie here - nice to be a part of the forum. Could someone please help? I am trying to calculate two fields together (to get a price) and then wish to add on 20% to that and round it to the nearest fifty, for instance £837.60 to £850.00, is this possible please? I seem to remember...
  15. S

    Changed spreadsheet from english text to what looks like code

    Hello, Many years ago on excel 2010 I tampered with a spreadsheet I made after I saw a trick online that made the text unreadable (sort of looks like code) but it was not encrypting it or using any type of formula. Just trying to use the spreadsheet now (7 years later) and I cannot for the life...
  16. P

    Dynamic range for VLookup

    Im looking for the syntax to set the formula in a cell to a VLookup based on the total count of rows in the lookup table. For example "VLookup(A1,Sheet1!B1:K500,5,False" where K500 might change from 500 to some other number depending on how many rows are in Sheet1 with data in them. If memory...
  17. S

    Search Mapped Drives for File Name

    Is it possible to have vba search through all mapped drives for a file name and open that file? I am trying to make a previously written code bullet proof by giving the users the ability to have a file that the macro uses saved anywhere rather than force them to remember to save it to a...
  18. N

    Keep the trailing zero's in TEXTJOIN

    Greetings again! Is there a way to get TEXTJOIN to keep the trailing zeros when having it pull numbers? I have the reference cells set up to carry out to three decimal places. When I use TEXTJOIN to combine data (text and numbers) it's removing the trailing zeros that I need on my numbers...
  19. D

    sumif cell color is

    I want to count the number of cells that have a shaded color lets say yellow. Can I do this without VB? If so how? I remember once defining the color as a number somewhere but forget how I did that. any help would be great. thanks Heller
  20. H

    Opening on last saved position

    In Excel 2016, opening a file takes you to the cell that was selected when the file was last saved. And actually I think the cell position is saved separately for each individual worksheet. This is acceptable behavior in most cases, except when emailing a large file (with many worksheets) to a...

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