creating

I am a student in Excel with limited knowledge. I was trying to do one project and while creating a table I choose "my table has Headers". My question is; how can I remove Filters arrows from the header?

I have 5 variables in that stores row numbers, I need to find out which has the lowest value and then put that value into another variable is there a way to do this without creating a horrible nested IF ELSE .?

Hi All, Is it possible to have a command button on a sheet which when pressed creates a copy of the sheet and puts it at the end off all the existing sheets but also has the command button on it, so when I've finished filling in the new sheet I can keep creating new sheets? Thanks

Would like to reach out to this community to ask for help. I have been creating some user forms in Excel but I am stuck when it come to creating user form to enter customer orders. Any recommendation would be greatly appreciated. User Form would generate a SO auto number 1234, however would...

When I create the Chart on a worksheet, the Excel file name is being used in creating the Chart SeriesCollection. I am struggling with figuring out how to pass the Excel file name as a variable when creating the chart. I want the user to be able to call the Excel file whatever they want vs what...

Hello, I would really appreciate some help creating a chart that illustrates the various stream velocities with respect to stream depth. I have the values for both velocity and depth, as well as section midpoint values. I just have to know how I would go about creating a chart like this in...

I'm taking four tabs in an XLSM file and creating a new XLSX file. The XLSM has many tabs, and I'm creating 10 XLSX files from this one big XLSM file. When I run my macro, I'm getting the below message: The following features cannot be saved in macro-freeworkbooks: VB Project To save a file...

I have two cells on one worksheet that are in random locations. One cell is named A and the other is named B. How do I get the color of cell A to be the same as cell B? Cell A is currently red but cell B is green. How do I get cell A to be green without using vba?

Hi Team, Can you please help create a VB which is helpful in creating pivot table and also details for each sub total in separate worksheet . Sub totals from pivot table must be moved to new worksheet of same workbook. kindly help.

Hi guys. This table is an example of what my ws looks like, I would like some help and information on how to code the action of creating the numbers you see along side all the records in column "C". I have tried with a macro, but it does not give me enough of an understanding of what is going on...

Hello All, I'm trying something I've never ever attempted, and don't know where to start. Creating a PDF from a Chart. I have an excel sheet, with 8 tabs Each tab has data that is used to make a simple line chart I want to have code, that takes each tab, one-by-one, and creates a chart in PDF...

Looking for a little input and suggestions before getting started, or if someone already has this, great! I receive emails that reference specific locations in the Subject line. These need to forwarded to certain people based on that location name. No problem except for the quantity. I plan to...

While it sounds relatively easy, I am experiencingdifficulty creating a formula to validate the actual result. Within the rangeto be calculated, data includes 0’s, no numbers at all and/or text. For thiscalculation, I started with =AVERAGEIFS(D4:G46,D4:G46,">0",D4:G46,"<>"""),butnoticed it...

This question might be really basic, and I tried googling it but I can not find anything. How do I create a button to run my code? I start with creating an ActiveX button then put in the code, and saved it as a macro enabled workbook, and when I click the button nothing happens.

Hey all, I would like some help on creating a stopwatch that works every time a key is pressed and stops every time the same key is released. A pop up that should let the user know for how long the key was pressed for. This should work for any key. eg format for the pop up window The key...

Hi guys, I have the following code that runs through multiple sheets creating a named range/print area - to fit to one sheet in readiness for printing. It is successfully creating the print area/named range on each sheet (that has a numerical name) but it is not setting it up for printing on...

Hi all im creating a chart for the 50 US states, what i would like to do is have some states match up and others wont, example , CA to NY is fine but NY to CA is bad , CA to AZ is fine and AZ to CA is fine the NY to AZ is bad and AZ to NY is bad

Hi everyone, I have a problem with calling a specific range from a workbook in its specific sheet by having them in the strings and then referring to them in the different workbook by creating a formula in range. (Maybe there is another easier way??) I need to make it like this because macro...

My spreadsheet is getting too cluttered with buttons, menus, text boxes, etc. Is it possible to create a custom popup menu that contains multiple form/ActiveX controls and appears when the user clicks a button on the spreadsheet? I found this basic tutorial here...

I usually get an error message whenever I am creating a form in excel using the "form" option in the Excel ribbon because I have a lot of columns which consequently means I am gonna need a lot of fields for the form. Is there any way to remedy this? I was thinking that maybe it is possible if I...