General

how do i merge the datas in 2 columns
i have a data address data in 3 columns like door no. in one, street no in another & city name in another column. shall i get all these address in a single column (consolidated) Thanks ... 19 May 2010 14:55

How do I set up more than 3 conditional formatting?
Hi, I have 6 different investigation area, one single name each, and I would like to set 6 different conditional formatting. But I'm not able to set more than 3. Any idea how can I manage it? Many thanks ... 19 May 2010 14:55

Averaging weekly data into Months
Ive got a string of weekly data ranging from 1993-2010, which i need to convert from weekly to monthly. Id like to do this so that in the future new weekly data can be automatically converted to its monthly average. Whats the best way to do this? ... 19 May 2010 08:15

Compare Sheets and highlight differnce
Hi All, Is there a way to compare contents between two sheets, and use conditional formatting to highlight the difference without using Macro? I am looking at data of A10:T140 ... 20 May 2010 15:01

Macros in teplates
Hi Quick question - can Excel Templates contain macros? Thanks A ... 19 May 2010 08:15

Macro-save to html
Hi, i have a macro that save excel file to html, and i need a macro to add a script to html when saving. Can this be done? Thanks! ... 19 May 2010 02:51

sorted running balance
i have a sheet with a running balance. This running balance is for all clients. I need a formula that will recalculate the running balance when i sort a client. The running balance formula keeps track of the hidden rows giving me a false balance for that client. Need that to be able to print statement history... 20 May 2010 17:14

Macro or VB code to hide and unhide Label box
I need your help to create a macro or a Visual Basic code that do the following: I have a cell with a macro that shows “Meets” or “Does not Meets” depending of the result of other cell. That I'm trying to do is a macro or visual basic code that display a Label box when “Meets” is showed and hidden it when “Doe... 18 May 2010 22:32

Rounding up
Hi Please-How do you round up to the nearest $1000.00? Thanks! -- OneFineDay ... 18 May 2010 19:16

Macro problem
Hi, i have a macro that save an excel file, but i have another workbook in the same folder. i need to replace that file. I need the macro to ignore the message that ask me if i really want to replace existing file. Can this be done? Thanks! ... 19 May 2010 02:51