General

Upper Case Letters to First Letter Upper, Remaining Letters Lower
How is this done in Excel 2007? ... 25 Feb 2010 13:43

Transport row`s data into separate etiquettes
hello, I wanted to make the data in the rows to be settled as etiquettes for later printing. I heard there was a way to transport them automatically. I would appreciate any answer, thanks. ... 24 Feb 2010 10:53

Use footer with freeze panes
I would like to be able to use headers and footers and still freeze panes. Is there a way to do this? If not, why is it no longer possible? I'm almost sure I could do this in the earlier version of Excel. Thanks. ... 24 Feb 2010 08:38

rondebruin.nl/code.htm
I am getting the error subscript out of range. I entered Example 1 into a module. ... 24 Feb 2010 08:38

Look up across multiple sheets
i need to look up a list of names across multiple worksheets in two different workbooks then return the oldest date associated with that name. How can i do this? How do i look up the Column A in workbook 1 amongst all the worksheets in workbook 1 and 2 so to return the latest date in workbook 1 or 2. example... 24 Feb 2010 09:45

Compare data in two different workbooks
I've got two workbooks that have similar data that have been extracted from different sources [ one is MSP the other is an in-house application ]. Both sets of data have similar values in columns [ ie Item ID, Item Status ]. What I want to do is do a compare between the 2 and then list out the discrepancies b... 24 Feb 2010 06:26

open excel file
Hi i have a excel workbook. and there are 5 worksheets only. it takes more than 3 minutes to open. and when i click to one of the worksheet it gives me a error message "not reponding". any suggestions ... 24 Feb 2010 05:21

INDIRECT FUNCTION
I have a A1 with a formula ="+2+2" I thought =INDIRECT(A1) would reflect 4 whereas it is returning #Ref! How to carryout the desired function? -- Thanx & Best Regards, Faraz! ... 24 Feb 2010 07:32

Excel Files Stopped working in windows 7
Hi frndz.. I have some excel files that are interlinked with each other. When ever i open these files in 2010 excel 64 bit, iam getting 'Excel Stopped Working'. These files runs under excel 2010 32 bit. I have read some articles related to this issue and found that the problem is occured because of bluetooth ad... 24 Feb 2010 00:58

How to apply Macro on a same type of format but in excess content?
HI, First of all i 'd like to explain what problem i'm facing. See i've data in three Rows and three Columns. I've recorded macro & i applied the same macro in same formation. like three Rows & Three coloumns. But the question here is now i've Five Rows & Five coloums. Now if i apply the same ma... 24 Feb 2010 09:45