Search results

How can i get excel to auto delete any cell in a worksheet is older than 30 days. This will keep only cells with data under 30 days in the worksheet. 4 instance i'm doing a survey 4 a new product. I have a database of 2000 names&mobile numbers in a worksheet. New names r added everyday. There...

Thank u Narayan 4 the link. I am checking that out. Thanks again.

Hello Hui & thanks. Typically, the Supplier Names would be in a different workbook or worksheet. A cell comment would be too obvious to anybody moving around the workplace. So, as i move the cursor over the Supplier Code, i would like 2 c the Supplier Name appear. Much appreciated.

Hello Friends & Greetings! In an Excel worksheet, using over 200 rows, i have in col A Supplier Codes & in col B i have the Amounts. The Amounts get updated periodically; but the Supplier Code is fixed. What I want Excel 2 do: When I move the cursor over the Supplier Code, the Supplier...

Cool solution Anupam. But Simon used the word "added". So the "&" symbol in ur formula should be replaced with "+" Cheers!

Hello Narayan & good question. But the input is from different data sources & here's my solution. Copy column A to Column G. Copy column B to column I. In column H enter the formula Vlookup(G2,$D2:$En, 2, 0). Copy this formula down to $Hn where n represents the last row of the list. Cheers!

Hello friends: I have List_01 that contains 2 columns A & B. Col A contains Sales_Reps ID # like 1, 5, 4 etc. Col B contains Sales_Revenues. I have another List_02 that contains 2 columns D & E. Col D has the label Sales_Rep ID, strictly in ascending order…such as 1,2,3,4 etc. Col E has...

Very many thanks, Sir, Excel Ninja. Most definitely, i will try out ur options.

What is the above all about.??? I never knew Excel had a 'religious' side to it. Anyways....to err is only human.

Hello Excel Ninja Hui & Sajan & many thanks. I will try to upload the sample file if possible. But here's the scenario: Just visualise catalogues (abbreviated as cat) coming in & issued out. U have an excel sheet named Day_1 to enter Cat ID numbers. Some have the negative symbol to represent...

Greetings friend & here's my Q. Catalogue is abbreviated as Cat. In a worksheet named Day_1, i enter Cat #01 in cell A2, Cat #16 in cell A3, and so on. These are for catalogues coming in. For catalogues issued out i would like to use the minus symbol. For instance, in cell A18 i enter -Cat...

Good day vengal1987.... Add the footer to the Default Workbook and the Default Sheet. Try this out: Select all the sheets in a blank workbook and then add the footer. Ungroup the sheets and save the file with the name Book. Save it as an XLTX file. Save it in the XLStart folder. - do a...

Hello guys. I have a 700-line database of guitars (Ashton), organs (Yamaha), speakers (Savoy), display stands (Barkan)...etc., etc. My Q: The moment i make an entry for guitars in the master, i would the entry to get auto-entered in the respective worksheet named Ashton_Guitars, (same roW and...

• Hello friends.. Time is a key factor 4 all of us, but i managed2 solve the Straight Line Depreciation part using a simple macro. Sub SLDepr() ActiveCell.FormulaR1C1 = "100" Range("B2").Select ActiveCell.FormulaR1C1 = "=R2C1*10%" Range("C2").Select ActiveCell.FormulaR1C1 = "=R2C1*10%"...

Hello friends, this is what i finally got. If your denominations are in row 1 from cell B1 and salary in column A from cell A2, then you need 2 formulas only B2=INT($A2/B$1) and copy down C2=INT(($A2-SUMPRODUCT($B$1:B$1*$B2:B2))/C$1) and copy right and down. Best wishes, James

Greetings! Here's my Q on Depreciation (Depr), that needs 2 formulas in Excel. I would like 2 buttons on worksheet #1. One button is named Straight Line (SL) & the other is Declining Balance (DB). If I click on the SL button, an excel formula for SL gets activated, and cells A2:M2 r filled...

I like this "volatile" discussion on the INDIRECT fx. And thank u Jeffey 4 so much clarity. I am saving it in my "Chandoo_Likes" folder. Thanks, James

Very many thanks Ninjas. This was the first time and in Excel only. ( I was using as friend's computer). But what Excel Ninja Hui has finally suggested has solved the problem. Regards, James

Thank u JB, Sir. I am trying it out. Regards, James.

Hello friends, Excel files with multiple sheets often crash. (I have some excel links; but no VBA etc). My machine have 32GB RAM, 64bit on Windows 7. Its very frustrating when you have just 2 sheets. I tried to open a 3rd sheet & it crashed. I can understand if my file has half a million...

Thank$. That was quick! Interesting. I am studying it now. Stay blessed. James

Greeting$ friends. I go the bank to withdraw 200,000 to pay salaries every week to 200 temp employees. Each emp receives a pay-packet that contains: 2000, 1595, 2675, 1055, 965, and so on. Denominations of the currency are: 1000, 500, 100, 50, 10, & 5. What i need: An Excel formula to...

Rest In Paradise...Dave.

Many thanks, oldchippy.

Hello friends, The =RANDBETWEEN() function can populate a range of cells with random numbers if u hit Ctrl+Enter. Is there a way to customise the function to populate a range of cells with 'random colours' ?? Thank$.