Search results

Hi there, I have a pretty large macro that I run to validate the accuracy of data in a file. Right now the code has 100 + formulas referencing static ranges and performing calculations. The only problem is as the file grows in size with time, these formulas will need to reference the entire...

I want to build a formula that I can drag down to replicate the string of dates in the attached file. Based on a start date and anniversary date, I would like to have the date increase each row by one month, with the same day value as the anniversary date, unless that day falls on a weekend or...

Hi, I would like some help using multiple nested IFs and concatenation to develop timestamps. See the attached file. Column A: The timestamp "code" (d=days, h=hours, m=minutes, s=seconds) I would like applied in concatenation. Column B: The time data, in hours. Column C: My current solution...

Hi, I am having trouble conceptualizing which formula or combination of formulas to use in this scenario. . . Imagine 2 data sets that come from 2 different database tables: Table 1 contains a list of Car Parts and their respective cost. Table 2 contains a list of Cars, and the Car Parts...

Hi Everyone, I have attached a sample of what I would like to accomplish using a Pivot Table. Say I have a group of individuals to whom I would like to distribute samples of my products. Say that I have a limit of 2 on how much of any product I should give any one individual. The table in the...

Hi All, I have created a materials order tracking log (attached) for a friend. The ‘Orig’ tab is what he gave me, and initially had used colored rows to separate the different systems (column F) which caused him problems when sorting. My solution on the ‘Work’ tab was to conditionally format...

Hi Chandoo.org, First off, I want to shout out my appreciation for this site: Recently I was in an interview for a Business Analyst position (praying for an offer!!) and I razzle-dazzled the interviewers with three nuggets of Excel wisdom that I learned directly from Chandoo.org! 1)...

I have been playing around in Excel and I have some US presidential data that I want to make a little interactive. I am really just messing around with INDEX(MATCH()) and Conditional Formatting. Right now I have it set up in cell B2 that you can select an ID tied to a specific president with...

Hi, I have daily data that I graph with an area chart. How can I get the graph's x-axis to plot by month? So in the attached file with 3 months of data, the x-axis should only read Jan-Feb-Mar. Is this possible? It would be really nice if the labels could be aligned with the data. Thanks.

Hi everyone, I was inspired by this interesting article to incorporate a pop-up calendar in a file I have created for a colleague. I opted not to use the Microsoft Date and Time Picker Control 6.0 and instead use the Microsoft MonthView Control 6.0. The code uses a named range and...

Hi All, I have attached the file I am working on, which is designed to be used by pretty much everyone in the company. The user selects from a dropdown in column B. I have vba that populates a 'billable rate' in column D based on this dropdown selection. I want the yellow highlighted portions...

Hi all, I have been picking apart an Excel file with a lot of code in it, in an attempt to recreate the file and understand the vba behind it. It seems the public functions are all being initialized with the same structure, declaring a variable as a "RegExp" which I believe stands for regular...

Hi everyone, I have made a new years resolution to keep track of my finances. What better way to leverage Excel and it's capabilities with VBA?? I am able to download account activity into csv files from my banking website. I am writing vba to take the raw extract file and format it to my...

Hi, I am using a trigger event to create a word document which pulls information from the target.row that initiated the trigger event. I can get most of this done, but it gets tricky when I want to put some of the variables I define into a Word table. To clarify, I want to create a new table in...

Hi everyone, I have created a file that I would like to share on Sharepoint 2007. I have selected the Share Workbook option within the excel file, but every time I try and have multiple users open the file, the excel file opens as Read-Only ("This workbook was opened from a server in read-only...

Hi, I have a workbook with lots of ComboBoxes. They are all "Yes/No". When I save & close and then re-open the workbook, the ComboBoxes that previously had "Yes" or "No" values selected are now reset to blank. How can I retain the values in the ComboBoxes that have been changed so that the...

Hi: I have drafted up a sample of my problem. Here is the link. https://www.dropbox.com/s/fg50jrb7dbg79ur/txtbox%20userform.xlsm As you can see my table has a ton of combo boxes. For the sake of my question we are only concerned with the combo boxes in the 'Notes' rows (5, 9, 13, 17, 21)...

Hello, I have to imagine this has been asked before....but I cannot seem to find a solution that has worked for my situation: I want to ensure that every field in my userform is completed before the OK button is enabled. In total the userform contains 9 textboxes, 2 combo boxes and 1 list...

Hi, I have a list of data that will be changing. This list can span multiple months/years. I wanted to produce a "top 10 list" from this data. I can do this manually, through use of large formula but I want vba to be able to do this without referring to specific ranges. I am not too familiar...

Hi, I have a scrollbar that I use with a dynamic chart that goes scrolls through quarters of data. I am experiencing significant (2 sec) delay from when I click the scrollbar to when the chart reflects the update. Does anyone know what might be the cause of this delay? Thank you

Hi, I have a column that contains text strings and I want to count the number of times any cell in this column has a specific word in its text string...so say my column has values like: Meals-Breakfast Parking Meals-Lunch Lodging Taxi Meals-Snack Meals-Lunch Airfare Meals-Dinner Meals-Snack I...

I want a combobox that updates whenever a button is clicked. I have tried using a dynamic named range along with the .RowSource and .ListCount properties but have had no success. The combobox lists years that correlate to the present data. When a new year of data gets added, I want the...

Hello, I have a simple bar chart listing employee data. I have cleaned it of the normal chart clutter (axes, gridlines, category name & legend) and want to add some dynamic data labels. I have added a combo box control to the chart as well as a dummy series so that you can select any employee...

Hi, Last week I was working with Excel 2007, and I had created a workbook that used the Microsoft Date & Time Picker a number of times. I have distributed this workbook to a number of colleagues...and have since upgraded to Excel 2010. Now, when I open the workbook, a big ugly red X appears...

Hi, Talked with my boss today and he said the company will pay for me to go to Excel School!!! I'm a little excited. Anyways, before I go through with the purchase I wanted to know if there would be any issue with me accessing the program and materials from both my work and personal...