How can I set up a pivot table that will group dates into 5-day weeks? Thanks -- Mike Gudyka St.Charles, IL

I'd like the ability to add a row with specific text in a worksheet multiple times. But the trick is I need the rows to be entered at certain locations and not...

I need to know how to change a default setting. When I open a text file (comma seperated) on my computer, I right click on it then choose "open with Excel."...

I've got a dual monitor setup, and want to configure Excel to allow me to open a spreadsheet in a new instance, so I can look at two spreadsheets,...

Hello all, I'm looking to find the word "Credit Card Information" in column A and then return the value or text in the cell below it. So, the word "Credit...

I'm currently collecting contact info from States which consist of primary and alternate POC's. One State may have 7 POC's and another 10. I received them...

How can I determine the standard deviation of only the cells I have color filled?

I would like to know how I can get excel to give me a list of materials from a "cut list".

I have a list of entries and some have US city names and/or states. I want to be able to identify those cells that have a match for a US city or state in the...

First post ever,I have a wks with column headings that say date,litres ,% every week i add these three columns to the wks. In another wks i want a formula to...

How can I link the data in a pivot table to the data? i have data in one sheet and i made a pivot table on another sheet. When i updat the data (i am not...

When copying between two Excel 2007 instances, The program quits copying off the clipboard, then I you restart Excel, it tells you the file is corrupted,...

Hello, I have the following existing code which look at a column "I" and if the word "ASC" text is present in the cell, then skip filling the data in column...

I am using adobe acrobat professional 6.0 and excel 2003. I am having a problem converting entire Excel worksheet to PDF. I've tried several suggestions...

I did a spread sheet to track payments and the percentages of those payments bi-monthly over a 12 month period. There are 6 percentage columns total for...

I have removed the read-only checkmarks from my Excel documents, but when I send them to a colleague, they appear as read only. I am using Office 2007. He...

I keep receiving this error and I can't figure out what i've done wrong, any help would be appreciated. Thanks Workbooks.Open Filename:="C:\Temp\Mgmt...

I have an ongoing issue...various spreadsheets (none in particular...could be one or two or all of them) will start taking on this behavior for no...

I cannot figure out how to keep all the task options showing when I click on a ribbon button, i.e., Home. I have to repeatedly click on Home (or any other...

Hello Experts! I have a single range B2:B50. Within this range are three contiguous ranges that are ever-shrinking or expanding depending on user input. At...