ways

Hi, I've been trying to search for ways on how a userform can function as an inputbox of type:=8 but still got no luck. Basically, what I want is to let the user choose a workbook and a worksheet that is why I use the type:=8 of InputBox method but I want to replicate it using a userform because...

Hi, I have a question about Pivot table and slicer. The slicer looks fine under normal view, but when I go to the print preview section, the slicer text doesn't look right because the font size is too large. I have tried different ways to change the size of the preview, but it still doesn't...

Hi all. I have a spreadsheet that i use to keep track of my sales accounts. On that sheet I have dates that actions need to be done. I,m trying to find out if there is a way of either creating some sort of notification, that would appear when i open the sheet, or that could transfer the...

Hello friends! hope all is well, I created a name range called Col, it counts the number of rows. I am trying to replace the number 1000 with COL. Can that be done? I tried severa; ways, but no luck...

Hello, I am trying to create a final score ie... the team won 2 - 0 or 15 -5, however, I have tried to customize this different ways and Excel keeps defaulting to random numbers. Please enlighten me. Sincerely, Cristine

I need help combining the following 2 IF statements:=IF(D3="Y","Y",IF(D3="N","N","")) and =(IF(F3="pos","Y",IF(F3="neg","N",""))). I have tried multiple ways and it keeps erring out on me.

Hi, im fairly new to ms access, and im working with org charts for this project. I wanted to know if there is a way to extract the data from an org chart and store it into a database or vice versa? I saw some ways using visio, unfortunately i dont have access to that. any and all help would be...

Hi - I'm wondering if someone can help me out. I have a table that has carrier name and below the name is the various prices. Some carriers will have "N/A" if they do not service certain regions. I'm trying to find a way that will review all the rates and provide to me the carrier name that...