couple

First of all, congratulations for this great Help Forum that has gotten me out of a lot of trouble on more than one occasion and your tutorials and ideas provided are great. I have a problem with some crossed data with which I can not get away with it, I do not know if it is very complicated to...

I'm working on a Schedule with a couple hundred people and forecasting it out a couple months and am having trouble getting some conditional formatting to work with the table. The example is a 8 days (D3-L3 is 7/5-7/13). I would like the names of the people (in the column B4-B7) to be...

So, i have this formula =sumproduct((H2:H500,"Job 1")+(K2:K500,"200")) Problem is sometimes K says 200, others its 200/tire, etc. Is there a simple way that anytime it see "200" that it will count? Basically i have MX events to also track and trying to automate the tracking. I did try "*200*"...

I have a couple of hundred rows that I want to vlookup and I have over 100 data tabels, when I change a combobox a couple of thousand formulas recalculate. And it takes a couple of seconds to recalculate and I am looking at ways to increase speed. Will it be faster do load every data table...

I have tried to post a question with a couple of lines of example, but it only posts the first couple of lines -why?

As per thread title - I was looking to edit a column chart so that [only] a couple of the columns were very close together. Any help gratefully appreciated.

I have been working on this spreadsheet for a few months and it is just about ready for prime time. Unfortunately it has decided in the last couple days that it has links and it asks every time I open it about refreshing them. The links are phantom and don't exist anywhere except in the warped...

Test Doh. Is it possible to put images of screen shots in posts?

I have a file with 40 plus couples with last names, first name in two consecutive rows of a column. I have another column that has a single value. The values for each couple ie two rows of a column is different. I want to sort the file keeping the couples together but sorted by the value of the...

I have a personal add-in module that I have used for years. It is called zzz add-ins.xlam and is stored, along with a couple of other add-in modules, here: C:\Documents and Settings\Administrator\Application Data\Microsoft\AddIns It contains dozens of UDFs that I have written over the years and...

Hi all, I'm hoping that there is a possible solution to my dilemma. My intention is to create an electronic contract system using mail merge, excel vba, and PDF manipulation. However, I'm trying to automate the process as much as possible. The desired result is to email PDFs to 1000+...

Hi there, I am currently using the following formula in a spreadsheet, however I am trying to include an IFERROR option to pick up cell Q3 if there is no match. I have tried a couple of options however they do not seem to work...

I am trying to write VB code to pick selected tabs, reference cell A1 in that tab and rename the tab. I've literally only started using VB a couple of hours ago but I'm a long time excel user. I read a couple of threads on this site that were answers to similar questions I was asking but not...

Hi all, I am running a macro to delete and hide some columns of weekly data to quickly create a sheet small enough to print out. I want the macro to automatically replace a couple phrases such as "single family" with "SF", and "new construction" with "NC". How can I incorporate this into my...