OK, its been awhile since I've posted but this group is the best.. Here's my problem: I am using data validation that is connected to the 2 categories...

Dear all, I try to record a marco in Excel but I can't find the marco button which shows the start/stop and reference cell slection. Please help. Kent

How would i pull week numbers for our fiscal year, which starts 07/01?

If I have a datalist like the following, is it possible to produce a pivot table with a single row for each unique combination of values in column A and B? ...

Hi all I posted this earlier: Hi all, here is the layout of my spreadsheet: a3=apple a4=orange

Basically trying to take data from csv files and populate the Columns in a excel migration excel sheet template Cut & Paste seem like the worse...

Hi, I have a table that lists employee names and their payscale. I want to put this into a Christmas Tree chart (as a count of people per payscale) but...

I need to know how I can get an Excel spreadsheet that has to be in landscape to print ... into Word.

How do I change the value on the horizontal axis in a X-Y graph so that it follows the example below? X-axis Y-value 0.00 2 0.25 4 0.50 6 0.75...

Hi, I have written a macro to calculate a result based on 5 variables and then uses these variables to analyse a column of values. I would like to use the...

Both seem to change when you reopen the spreadsheet. I'd like the date I create the worksheet to be saved and not updated everytime I reopen it. Any ideas?

I'm trying to keep track of inventory using Excel. In B2, I have Initial Quantity. Then I have to issue inventory to 4 different departments. So, cell C2 is...

Hello, I have the following formula which is currently resulting in an error. It is checking the shiped date in column N and adding 1 day on against the...

How can I format my cell to display letters, a dash, then #s? For example: ABC-12345678, or 2DE-12347562, or FG3-46518673?

I have a summary sheet & 2 detail sheets in the same workbook. I want the header info from the summary sheet to copy to the 2 detail sheets. I've linked...

Can a VLOOKUP return a formula rather than a value? If not, is there any function that will return a formula? I have a spreadsheet where depending on certain...

The macro that I am looking for compares column A between 2 different worksheets(PTR and Reference data). If the Macro finds a match it takes that row from...

is there a macro that will put the start date and finish date for each of these activities as the 1st of the month is good:...

During vlookup ------ How do I bring the "font color" across with the data?

I didn't know where to ask. It would be easier to attach a worksheet to show the problem. Please point me in the right direction if someone could please. 1)...