tool

I am currently enrolled in an Excel course through my local college. We recently learned about the VLOOKUP function. It seems to be a very useful tool for work-related spreadsheets. Are there limitations of using this function? If so, what are they?

I am a big fan of the Quick Access Tool bar which I have customized to give easy access to my most commonly used functions. I have them grouped logically. For some reason the icons don't stay put. The icon in one location keeps moving elsewhere on the Tool Bar. Occasionally, another icon...

Hi, I use the excel camera tool a lot to create "dashboard" type of page. The issue is when I select the range and create an image with the camera tool, the "Scale height" and "Scale Width" of these images are not 100%. It is around 93~94% on height, and 67% on the width. HOWEVER, the image...

Was wondering if anyone could help me out with an Rating Percentage Index (RPI) tool. There used to be one at https://techgraphs.fangraphs.com/an-rpi-spreadsheet-for-you-yes-you/ but it seems it has been taken down. I am trying to calculate RPI for a sports project I am working on and the WP...

I am trying to find out if there is a way to automatically unlock a protected cell based on the contents of the cell. I have a spreadsheet that is password protected. I am looking for a way to unlock a particular cell if the result of the formula in the cell is an error or a certain result...

I'm building a tool to accommodate various reports where the the header row could be in row 1, 2, 3 etc. This tool will be used by a number of different employees. I need a creative way (using VBA) to determine what row the header is in. Management has asked me to prevent the macro from...

So I have a "Tool Bar" across the top of my worksheet that I want to remain the exact same size and position except when row 1 is hidden the tool bar should be hidden as well. If I hide columns etc I don't want the tool bar to change size but I can only seem to get it to either not size or hide...

Hello, I noticed that when I'm using "Freeze Pane", my Draw tool becomes greyed out. Is there a workaround? Thanks! Anita

Hello, I apologize if a similar question has already been asked. I am trying to generate a table from data that I've collected. I want to extract 3 data points, and the associated tool that have the smallest range from the whole sample. I have it set up where column D, F, H, J, L, N, P, R...

I don't know how to write VBA code very well so someone has been helping me with this code. The code is meant to copy the rows from the table in the quoting tool to the table in the costing tool. Here are some specifics Quoting tool Table Name: npss_quote Sheet name: NPSS_quote_sheet Costing...

Hi there Below is my code. It is very simplistic since I recorded the macro. It copies everything, text, numbers, formulas, dropdown boxes etc from one workbook to another. This code works well. Is there a better code I can use? I have many worksheets to copy over from one workbook to...

I do a fair amount of Excel Pivot tables and had considered getting of two Excel Add-ins that would help with speed of using Pivot Tables. Either Pivot Power Premium or PivotPal. Has anyone used both that could give an idea between the two? I don't need/want both, but not sure which is the best...

Hi, is there any chance to disable Snipping Tool to prevent users to snap the data and print it? Thnx

So I have a table with multiple columns, each representing a store. The rows are individual products while the value is the discrepancy of stock ie we are missing 5 stock (-5). Now I want some sort of tool that can calculate that if I’m missing 5 in one store, I can move 5 from another branch to...

Hi guys . . . I'm after some help / guidance.. I have 8.5 hours a day available (Monday to Thursday) and 4.5 for a Friday (07:00 - 15:30 & 07:00 - 11:30 respectively) I need to plan in a number of activities that could span over multiple days (in hours & minutes) I want to enter a start date...

hi , I have number in cell from C6 to C2500. something like 255, 240.50, 266.67, 312.25, 20.10 etc. I had insert spin tool from developer and i want to spin only this number in my A1 cell. so what i do ? this is image of my worksheet https://ibb.co/3r9pQCJ

Hello,<o:p></o:p> I am an Excel novice, but I need to complete this little tool ASAP, I’ve donesome research but realized very quickly I was either getting wrong or halfanswers. I’m hoping that the folks here can read the description of whatI want and lay out what I will need to...

Hello, I have forgotten the password to open the excel file. Is there any tool to open/recover file? Please help Thanks, Namrata

How can I declare the below objects without requiring the need to selecting them in the Tool Refences? Microsoft Internet Controls Microsoft HTML Object Library Microsoft XML, v6.0

I was attempting a find in vba...it was giving a problem so I tried to find the same value with the find tool in the worksheet. With all cells selected I opened find and entered the date "02/10/10", hit "find next" and got the result "12/10/10". What the heck? How, Why? anybody had this occur...