Search results for query: *

I have a spreadsheet with two tabs containing payment information, one internally generated and one from the client. My goal is to flag, or move to a new tab, the unmatched records so they can be investigated. Each record on both tabs has; Name, Acct#, PmtAmt, CommAmt, Date, and PmtType. A...

I have an Access query that passes phone switch data to an Excel Pivot Table. I use the following expression to parse the date Time: Mid([CallDate],13,5) which gives me normal looking time values like 14:52 11:33 18:21 etc. This is fine for display purposes but Excel is not recognizing them...

I have a column containing "lastname, firstname" I would like to have the last name only appear in another column. Can someone please tell me the formula to use? thanks!

I have a table with 4 columns; - agent name - department name - sales total Each day the table is sorted by who brought the most money in. I would like each dept. to have it's own font colour and/or shading to make it easier to spot people from the same dept. There are 12 different departments...

I would like to hide cells where the formula displays "FALSE". Turning the text white would be sufficent but I can't get it to work with conditional formatting.

I have a table of data with 'desk' names down the left hand side and the days of the month across the top. Each day the revenue for each desk is entered beside it's name under the column of the corresponding date. The table is 300 rows by 31 columns. I have created a report on another tab that...

I want to display "Posted on Mar 14" as a column label. The date portion is to be grabbed from another cell. I also want the label to be word wrapped so it doesn't take up so much space. I have tried using =Concatenate("Posted on ", A1) and it wraps fine but I can't the date to display in date...

I have a table that shows how much revenue each agent brings in each day. The agent names are in the first column and the days of the month are labelled across the top in the first row. Each day the previous day's revenue numbers are entered in the column for that day. I would like to have a...

I have a table that shows how much revenue each agent brings in each day. The agent names are in the first column and the days of the month are labelled across the top in the first row. Each day the previous day's revenue numbers are entered in the column for that day. I would like to have a...

Maybe I'm just blind but I don't see how I can make an hourly reminder in the calendar under the reoccurence options. Anyone know how?

this is a 2 part questions I think... when I receive an email, I would like to be able to file it in a folder and be reminded about it x days later similarly, when I email somebody, I would like to be able to say "remind me about this in 10 days" etc. so I can follow up on the emails I send...

I have an 800 number pointing to an ACD queue. I need to find out how many calls it gets each day. 1) What is the command for seeing yesterday's traffic 2) Can I pull a 7 day summary? 3) Is there a command to tell me how many calls a single extension received (ACD or otherwise) We have a call...

I need a macro that will automatically insert a blank row between every 2nd row of data in a sheet. I would prefer not to have to record a macro to do it because there's hundreds of rows. Any help would be appreciated.

Jaffey (TechnicalUser) 12 Jan 07 12:23 I have a spreadsheet with about 20 tabs. I need a macro to unlock/lock all of them. Problem is, sometimes some of them are already locked/unloced so my macro bombs. Sub Macro1() ' ActiveSheet.Next.Select ActiveSheet.Unprotect...

I have a spreadsheet with about 20 tabs. I need a macro to unlock/lock all of them. Problem is, sometimes some of them are already locked/unloced so my macro bombs. Sub Macro1() ' ActiveSheet.Next.Select ActiveSheet.Unprotect ActiveSheet.Next.Select ActiveSheet.Unprotect...

I have a macro attached to a control button that changes the date on 50 different pivot tables similar to this: Sheets("AMEX").Select ActiveSheet.PivotTables("PivotTable55").PivotFields("Date").CurrentPage = _"Mon 11/27" ActiveSheet.PivotTables("PivotTable38").PivotFields("Date").CurrentPage =...

I have to create pivot tables on a constant basis. The default number format is General. I am forever manually chainging it to Number with no decimal places and including a thousands seperator. Is there a way to make that the default?

Hope I picked the right forum.... I have a macro attached to a control button that changes the date on 50 different pivot tables similar to this: Sheets("AMEX").Select ActiveSheet.PivotTables("PivotTable55").PivotFields("Date").CurrentPage = _"Mon 11/27"...

Whenever I try to make a graph by selecting a row or column of pivot table data, Excel creates a whole new tab with a pivot table chart on it. Can this default be turned off? I'd like to be able to reference the cells directly from a graph on the same page as the pivot table.

I have a bunch of graphs where I've added a trend line and visually I can easily tell if the trend is up or down. however I'd like to add a comment section that says "Performance for client X is trending Up" or down, as the case may be. How can I tie a cell to the result of the trend line?