General

Having a macro/function available in new spreadsheets
Hi everyone, I wanted to define a function that would be available in all new spreadsheets that I create from now on, so I defined a macro in the Personal workbook (Personal.xlsb) and then manually pasted the code of function I needed into the macro, such that the code of the macro looked something like this... 2 Apr 2010 09:18

Excel 2002: How to select an invoice entry ?
Hi, Let's consider the table below: A B C 1 Invoice Line code Selection 2 2010030101 18 A 3 2010030101 2 A 4 2010030102 3 B 5 ... 6 Apr 2010 19:53

Vlookup based on a unique "Text" occur
My vlookup range starts based on a unique "Text" occur once in a cell in B:B and end when the same occur once in a cell in A:A Within this target range of rows there are unique texts like text-1,text-2, text-3… and so on belongs to the "Text" and they are in A:A but unevenly spaced. I need vlookup values loc... 2 Apr 2010 08:12

Changing Arbic numeral to Hindi numeral
How to change Arabic numeral to Hindi numeral in Excel 2003 ... 2 Apr 2010 07:07

How to delete cells with a given data?
I'm trying to delete series of cells with a given word inside, but there are too many to FIND one by one and delete them. ... 2 Apr 2010 10:24

Saving an Excel Spreadsheet outside of Excel Recent Documents
Okay "boys & girls" you may think this is a primative question, but I just can't figure this out: When I save an Excel spreadsheet, the only way I can get back into it is to open up my Excel program > Open the file I previously saved. And that is not a problem. However, what if I wanna save that Excel spre... 3 Apr 2010 10:25

Moving Text from Word to Excel (and having it set into 2 colum
If your data is starting from 1st row use the below forumla:- Paste this formula in C1 cell =TRIM(B1) Copy and paste the C1 cell and paste it to the remaining cells of C Column. If your data is starting from 2nd row use the below forumla:- Paste this formula in C2 cell =TRIM(B2) Copy and paste the C2 cell and ... 1 Apr 2010 23:34

compile data base on hit
Before compile the data is: IP user name Hits x A 10 y A 1000 Z A 20 L B 2000 M B 10 N B 500 After compile the data is: IP user name... 5 Apr 2010 19:30

How do I parse the data in a cell
I have an excel workseet with the following type of data: white-jungle.XL white-jungle.XXL jungle-smoke.S berny blue-smoke.S berny blue-smoke.M I need to parse the 'sizes'(everything after the period) and put it another column. Any help would be appreciated. ... 1 Apr 2010 20:15

Outlook Calendars
I have users who are running Outlook 2003 if they add another user's calendar when they logout of Outlook and reopen the calendars are no longer present. They need to click on name to view calendar. Is their away to enable the calendars so that they are always present? ray3d84 ... 2 Apr 2010 03:53