Search results for query: *

Is there an easy way to base the name of a tab on a cell value. I searched the site but can not a related thread any help is appreciated.

I am trying to write a simple macro that looks through 20 values and colors the cells until it reaches the value that I have specified. I believe I am having a problem with the "with" section of this code. Any help is appreciated. Sub ColorUntil() Dim A As Range Dim B As Integer A =...

I am looking for some help with a database that I use. The database uses 3 large tables and has a few summary queries that pull information from the tables. The problem is that the tables are huge and have brought me to the 2GB size limit. I can no longer compact and repair to fix it. I was...

I am trying to find a piece of code that will neable me to automatically copy formulas from a range of cells (that will change) into a given range of cells (that will also change). I am adding data to the bottom of a list and need to paste a group of look up formulas to the left. The number of...

I am trying to write a Macro that will evaluate the contents of a cloumn and delete the entire row if the value in a cell meets a certain criteria. Here is what I have so far: Sub Delete_Row() Dim Mvalue Range(A1).select Do Until Mvalue = Null Mvalue = ActiveCell.Value If (ActiveCell.Value =...

I am trying to write a Macro that will look in the current folder for a file that will always be named and structured the same way and import the data into a sheet that will always be called the same thing. The number of rows on the sheet I am importing from will change. Any help is appreciated

Hi, I am trying to create a macro that determines the range of values and then creates a pivot table off of my data. The problem I am having is that the # of rows in my data set expands an contracts. If I use the Pivot table wizard it always refers to the range of the first time. Any suggestions?

I need help! I am trying to have the change in a cell value trigger the running of a macro. I am not concerned about what the value changes to, just that it changes. Thanks for any help.

Does anyone know how to create a drop down box that lets you select a Macro to run? Thanks for the help!

Does anyone know how to activate a macro with a file command (i.e. run a macro upon closing a workbook)?

I have created multiple reports that look to an external data source(another excel workbook) that use Hlookups, Vlookups and Sum ifs to populate the reports based on specified criteria. The reports work fine except that excel slows to a crawl (to the point of being prohibitve). Is there anything...

Does any know that max number of sheets able to be used in one workbook? And what would cause a sheet to need to be moved before the work book would calculate? Thanks!

Does anyone know how to write a formula or piece of code that would enable me to create a adjustable range in MS Excel. I am trying to create a year to date column of information that changes based on the month I input into a control cell. (ie input June and the range would sum six columns...

Does anyone know how you can consturct a form that has multiple combo boxes that are dependent on one another. The form is being used to select criteria used to query a master data set and filter the results of the query by the selected criteria. Any help is appreciated.

Does anyone know how to go about creating a list or report in excel that would have the ability to auto populate from a master table after the user choose criteria from multiple drop down boxes? Appreciate any help!

I use the sum function endlessly and I want to create a keyboard shortcut to insert the sum function. However, when I write a macro to do so it does not auto select the range. Does anyone know how I can write a macro to insert the sum function and auto identify the correct range. Thanks for any...

I am having a problem incorporating relative cell refrences into a macro I am writing (for example: Range.("RC[+1]").Select). Can anyone tell me what I am doing wrong? Thanks!

I have inherited a large database and I have been asked to detail how the database works. The creators have left and I am not the most proficient access user. Does anyone know of any program functionality that may be able to help me?