tool

I love the "send email to recipient" command and it works great for a tool I have in place to share updated negotiated prices. As I need more people to be able to use the tool, I have to consider their "limitations." Is there a code someone can provide me that allows me to create a button on...

i am developing a employee training tracker tool in vba. In a vba form,i am trying to create a training requisition of the departments. it has fields deptname,trainingname,list of employees ,requireddate,headname. how to display employee id and name in a list box and mulitple select it. how...

Someone sent me a workbook to look at "because its no longer working". What they sent was an XLA file. They said it use to add a ribbon to their tool bar but now it doesn't work with the latest version of XLS. Is this just missing a tool pack or Add-in that needs to be activated in her latest...

Hi guys ! Who can help? I need to visualize data in several coordinate systems - cylindrical and spherical. This is necessary for more accurate results. Is there a tool that will allow you to do this ? Please move the topic in the right section if I'm wrong.

Hi All, I am having a difficult time finding guidance on the right settings for Excel 2016 so that I can use Power Query. Most of the files I use are from my own desktop but I continue to receive this error message (Yellow Banner once I initiate the Power Query add in). "To help protect your...

Sir, Need to prepare gant chart in excel, in this Duration is mention in hours Start date=Manual input by user End date =Startdate+Duration(Hrs) Here Stamping die is the Tool and the applicable opeartions wrt to tool are given in hrs (Milling, Surface Grinding , etc). The operations for...

Hi Everyone, Long time Excel user who recently started a new job that involves lots of formatting with various company specific colors. I want be able to insert each of the colors to various cells quickly...ideally with just a couple key strokes. Thus my thought process was to create a tool...

Is there a way that I can connect powerquery to one main network folder, then pull in any excel file that is in that network folders sub folders? I am trying to come up with a budgeting tool for my company, I want to give each cost center their own network folder that they can access to enter...

I would like to build an "Update" Tool that would: Upgrade all Workbooks in a designated folder with: Macros Buttons Button Preferences (i.e. Color, Position, Title) Basically, this tool should take all above items from an existing (source) Workbook and update other (destination)...

Good morning, I now need to save the project I created in Excel 2010 as Excel 97-2003 so that my boss can try it out. Can anyone point me to a method or tool for checking compatibility of my current macros with Excel 2000? thanks much, Bill

When I use camera tool in Excel to copy a chart, I follow instruction carefully but the picture only shows part of the chart. How can I fix it?

Hi everyone! Please help me with combining multiple Microsoft Excel Comma Separated Values, I want to combine my 40 csv files in one excel without opening and copy paste them one by one, and everyday our production machine producing this csv file.After creating a macro tool, I hope this tool...

Hey everyone I want to create a workbook that keeps track of certifications of employees across different shifts. My goal is to have a master sheet that i update and have excel create tables in new tabs for each shift. I need the table to update when i change something in the master sheet...

Hi Everyone, I am currently looking for a way to have it so when a manager is working with an employee on their development plan they are able to have a quick way to plot multiple employees on to a 9 box grid with the click of a single macro. Both the performance and potential rating scale from...

Win 10 / Excel 2016 Hi all, I was wondering if someone could give me some pointers please... Long story short, i have a 'tool' that i created that will search a workbook for external links and list them in a text file. I've recently found an external link that my 'tool' wasn't taking into...

Hello everyone Did any of you set up an EXCEL file to use it as an accounting tool? It should cover the basics (booking, GL, Profit/Loss, BS). Any help is very much appreciated. Cheers, Peter

Is Power BI the collective term for the Power tools, eg Power Pivot, Power Query, etc. or is Power BI a separate tool itself?

Hello all, Requesting help from you guys. So basically I am doing a tool comparison and my final dashboard looks like below <tbody> Evalution category Tool 1 Tool 2 Tool 3 ABC 8 4 3 DEF 1 3 6 XYZ 5 2 5 </tbody> So what I am thinking is a way to highlight in which categories is Tool 1...

Good Morning! I've been working with Excel for a few years now and have increasingly been advised in the past to work with PowerQuery, especially for large amounts of data. Now I have a tool that builds on records that are updated every month in a folder or in a single file. For this purpose...

Hi all, I am currently working on a spreadsheet for a design I'm working on. I need to know how to get a cell to say, if another cell is: Between 890 and 915 say "GOOD" Greater than 915 say "LOWER" Less than 890 say "LIFT" I've had a go at using the IF tool but i can't find a way to use...