General Discussion - Page 402 - OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Thread / Thread Starter	Last Post	Replies	Views
Merry Christmas! by puiuluipui Merry Christmas to everyone who helped me, and as well as to all excel users. And Merry Christmas to all Microsoft Office programers! Merry Christmas!	December 25th, 2009 11:11 AM by puiuluipui	0	125
Find all item codes for all items under one category by Kevin K[_2_] I have a list of thousands of UPCs with the category name in adjacent cells. I need to build a formula to automatically populate a list of UPCs based on the...	December 25th, 2009 07:46 AM by ×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ	3	180
table by candi how do you create a table in excel based on the data you have in excel	December 25th, 2009 02:03 AM by FSt1	1	113
Moving Formulas when Sorting by Originalgoth Hi All & Happy Christmas & New year, How can I sort a table and have the formulas move to the relevant new postition? I'm working on a World Cup spreadsheet...	December 24th, 2009 11:41 PM by Originalgoth	3	134
Moving Formulas when Sorting a table by Originalgoth Hi All & Happy Christmas & New Year, How can I sort a league table and have the formulas move to the new cells? I'm working on a World Cup Spreadsheet. I've...	December 24th, 2009 11:05 PM by Originalgoth	0	122
Formulas stopped working - Auto Calc IS on... by Nascarfan88 I have a spreadsheet with several formla calcs that worked fine yesterday, but not today. I've checked Auto Calc and it is on. Any help/suggestions would be...	December 24th, 2009 09:41 PM by ×ž×™×›××œ (×ž×™×§×™) ××‘×™×“×Ÿ	1	147
Top 3 scores by Gilbo I have a spreadsheet with columns A - Teams, B - HomeScore, C - AwayScore. I want find how do i find the top three scores in homescore and also pick the...	December 24th, 2009 09:13 PM by gil_wilkes	3	159
Options Button (forms Contrrol) by texas2001 When I add pairs of option buttons in group boxes, when i get to the third pair the button automatically the control cell from the first group. The happens...	December 24th, 2009 07:48 PM by texas2001	0	157
CTRL+SHIFT+) is not working in Excel 2007 by Nagender Rathi Hi, I am using Office 2007 on Vista machine. When i am using CTRL+0, the excel columns are getting hide. But when i am using CTRL+SHIFT+), my hided columns...	December 24th, 2009 07:18 PM by Gord Dibben	5	113
Sandwich existing formulas with "If iserror(formula),0,formula)" by ORLANDO VAZQUEZ[_2_] Hi, I have several hundred different formulas on one spreadsheet like this one. =VLOOKUP($C$1,'P:\Rate Sheets\client name\manager... ( 1 2)	December 24th, 2009 07:13 PM by Gord Dibben	10	263
Rename Worksheet Tab as File Name Using a Macro by Cue Hello, I am trying to rename a worksheet tab using the name of the workbook. Each code I've tried does not work. Does anybody have a simple macro to... ( 1 2)	December 24th, 2009 06:38 PM by Cue	10	264
2003 Excel Pivot table data selection by bhudson I am currently trying to create a PT but my source data is more than the 65k row limit. Can you create a PT using source data from 2 worksheets and if so,...	December 24th, 2009 05:41 PM by bhudson	0	141
2007 version of Excel by Nikki How do I create a password so that the password is required upon opening the workbook?	December 24th, 2009 05:40 PM by trip_to_tokyo[_3_]	1	126
help with adding names by CHAD can i add a word before a sum from a different sheet. ie: i have a total on sheet 1, and on sheet 2 in a cell i place =then i click on the cell that i want...	December 24th, 2009 05:23 PM by CLR	1	159
lost graphics by Beancounter Hello I am using excel 2007 on a dual monitor set up. I have had a number of spreadsheets then when opened have "lost" all the graphics - color, underlines...	December 24th, 2009 05:10 PM by IA CPA	1	191
Creating formula in Excel by Josh Hello everyone. I am trying to create a formula in Excel and need a little help. I have created a workbook with my inventory in it. when the inventory...	December 24th, 2009 04:58 PM by CLR	4	171
complex count formulas using multiple criteria in different ranges by Nutmeg007 I am trying to calculate a count, if a range of cells meets multiple criteria. This formula is in an existing worksheet that I inherited and it works as it...	December 24th, 2009 04:18 PM by Bernard Liengme	4	143
Excel 2003 printing problem--printing 1 document on 2 pages by Bons Hi All!! I looked through the printing probs section and didn't see anything like this....but I KNOW someone will be able to help with this. We have a...	December 24th, 2009 04:15 PM by Bons	0	138
Copying only subtotals by Connie Martin In doing DataSubtotals and then clicking on the 2 to show only subtotals, how do I copy and paste only those subtotals into another spreadsheet without it...	December 24th, 2009 03:51 PM by Connie Martin	1	159
Automate copy / paste by PAULGOR via OfficeKB.com Good day , I am asking for help with the following matter please. I need to copy a single row on an XL database worksheet, and paste to...	December 24th, 2009 03:38 PM by PAULGOR via OfficeKB.com	1	153

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed