remember

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

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

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

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.

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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