tool

Hi all, I work a lot with excel and power point. We use excel as the source file for tables and graphs which are copied to power point using a designated tool which allows you to copy the items as images and then automatically update them in PPT once they are updated in Excel. The issue I...

Hi everyone :), I have a long macro code and I'm wondering if there is a way to simplify it since it has been created from the macro recorder tool. Here is the macro code: https://anotepad.com/note/read/6n32gn I hope that my post is clear enough. Thank you.

I hava a workbook that has 2 worksheets. Worksheet 1 contains a list of master blanks and their Outside Diameter sizes (range name MasterBlank) Example: (OD = Column A and Master Blank = Column B) Column A OD 10.759 10.760 11.000 11.500 11.935 11.940 11.950 12.550 12.630 12.950 13.000...

Hi I want to create a data log sheet for when I update various parts of my businesses intranet and am looking to incorporate a cell with a date selector (calendar style). However, due to limitations of the business network, I am unable to use the built-in calendar (developer tool?) with Excel...

Hi, I have two sheets, one is old and 2nd is a new version after some changes. I want to compare both sheets and want to highlight changes also if i can get old value and new values as well. could anyone help me please here . i dont prefer any 3rd party paid tool BTW.

Hi all I have about 100 workbook every one hour and I want to combine all of them using ablebits data tool But it’s not free tool and I cannot buy it I searched a lot but all vba macros I found in internet doesn’t work with me So please help me to find VBA Macro to do what I want Thanks :)

I have created a variety of template tools that I use to common size data from different sources. I keep them as a unique workbook and then copy the sheet to the new workbook for calculation. To the side, I have a column where I enter in the names of the sheets to use as source and the indirect...

I have built a tool on a different sheet, and it basically fills out 5 rows and 3 columns of data. What the tool does doesn't really pertain to anything I need to do, but I'd like to have a way to send the data that I use with the tool to another sheet in the workbook. So data in C13:E17 is the...

Hello guys, I wonder if you can help me. I have a spreadsheet that has three toggle buttons. One is called "Tool," one is called "Fluid" and one is called "Air." The idea is, if I hit "Tool" it hides fluid & air rows for each account. If I hit "Fluid" it hides tool and air, and if I hit "Air" it...

I have a large table with many columns. I would like to filter the table first using VBA and then calculate the percentile of a single column using VBA to store the data in a different workbook. I have cobbled together how I think it should work using other sections of my code, I just need help...

I'm trying to add to my quick access tool bar but it only seems to see macros WITHOUT arguments.

Hi, I have made an excel file where i want to do a few sensitivity analysis. To remain flexible, i have put a formula on the data that the what if analysis tool has to take for its calculations. https://imagebin.ca/v/3irbzK2IVH6D Like putting on a row -5% to +5% compared to my basic assumption...

Hi all, At my previous employer we had a tool/shortcut that allowed us to click on a cell containing a formula and then cycle through its precedents using shortcuts. The cycle was started off with CTRL+G (repurposed from Microsoft's default use) and then you could move to each precedent of the...

I am trying to set up a filter that will use the text from a cell to filter on. I have a user form that the user will select the product to filter for. This is recorded in cell EG1. I have a vlookup formula in cell EG2 that displays the info in the second column of a table with the filter...

Hi ! Does anyone of you here have experience with the Analyse tool of DPSC ? Ho was it working with it? Any tips on how to go about it as I am suppose to revive it and get it back in action at my office and I don't know where to start :P

Hello All, I’ve recently been given the task to create a pseudo-automated system that can have tools in a list output a user experience index based on a data set. As of right now, I’ve been grabbing the data manually and doing the math through a number of SUMIFS and AVERAGEIFS. You can...

Good Morning/Afternoon/Evening When I first opened a blank workbook and clicked on the Developer Ribbon and then on the Visual Basic icon, the VB interface was displayed but only with the top main menu (File, Edit, View, etc.) and three blank tool bars. See screenshot This is the first time...

Hi, Ill try and explain as best as I can Sheet 1 - Cell D5, We input our product Reference, In Cell E5 I want this to look our our database to see which tool is avaialable. (This also happens on every row down ie. D5, D6, D7 etc.. ) Sheet 2 = Database - Column "C" C7:C1000 contains all...

Hi all , I need small advice !!. everyday we pull data from Oracle business application which is web based tool and I daily pull reports for our analysis . so now my question is can we pull that date using VBA that interface with the tool and get the dump . and point to be noted there is...

Hello, Could you please let me know how to connect to tools(3rd Party tool) and extract data from there. For Ex: Any tool which supports SQL query. Regards, Chandrashekar B