Search results

Hello friends and here's something i just discovered and would like to share I was using the = RANDBETWEEN() to fill random numbers in a range of cells (B2:K200) and instead of using the 'usual' Ctril+Enter in B2 and then pressing the usual Ctrl+Enter, i used the 'auto-sum' button instead and...

I am using a Data Validation list to choose a 'unique name' from the DV drop-down list. Column A contains 2000 names. Column B contians the DV_List based on Col A. But since its quite a long list it becomes difficult to find a 'unique' name or value that I'm looking for. Here's the problem……...

I need to do some basic accounting using an Excel formula. Its like this: Cell B20 is labelled.....Profit_Margin_Slab Cell B21 has..................0% - 5% Cell B22 .....................>5% - =<10% Cell B23 ....................>10% - <15% Cell B24 .................=>15% - =<20% Cells C20 thru'...

Firstly, i am sorry the question has repeated. I am an aspiring VBA coder. So a VBA solution is cool. If u need a sample file, i will have to create one. Many thanks.

Hello friends: Typically, i have pie-charts to represent each major expense. The Budgeted number is blue. The Actuals have the colour amber. The Variable has the colour green for Surplus and red if there's a Deficit. My problem is how to keep the 'variable' colour dynamic......... To give an...

Very many thanks, Lohith. That's great! I'll stick to ur solution 4 now. Many thanks for ur time and valuable effort.

I am very grateful to Lohith & Narayan for their valuable time & solutions. Now, i would like to take my question to a new level......if that's okay. The moment i click the worksheet named Product_A, this worksheet selection must then trigger the opening of worksheet #1 (the master worksheet)...

In sheet #1 i have a pie-chart that contain 11 slices, each slice representing one of 11 products. Each slice has a unique colour and tells what percentage each product contributes toward overall sales. The sheet is password-protected. Sheets # 2 thru' 12 are named after each product. For...

Here's wishing Dr. Chandoo & family and all Chandoo members: Best blessing in 2014.

@SirJB7: Thank u for your input & blessings.

@BBD: Thank you very much. That was simply awesome…..and gave me new perspective. Stay blessed.

Hello friends: Worksheet #1 contains lots of first-names. Really can't tell ya the number of it all. For instance, the name 'Amanda' may appear a number of times in different cells in the worksheet. Ditto for 'Belinda', Candice, Samantha, & James. Each name may appear 20 times, 50 times, 99...

Greetings! In a workbook, i have 20 sheets of data. Now i have some new data that pertains to sheet4 & sheet5. So, for the sake of convenience (and quick access), can i insert a sub-sheet between sheet4 & sheet5.? I know i can have my data in sheet21 and then drag sheet21 to in-between sheet4 &...

@kchiba: Perfect. Thank u.

If i want to colour-format EVEN rows the Formula is: MOD(Row(),2 = 0 To CF every 3rd row the Formula is: MOD(Row(),3 = 0 To CF every 5th row its: MOD(Row(),5 = 0 So, based on the above; its the 'divisor-number' that decides which row gets coloured if the equation is set to zero & with Excel...

Hello Sajan & thank u 4 that very useful link.

Thank u guys. Very cool.

Data has numeric values in each cell and each cell has a smart green tag. All this is in a single column. Lets say, J2:J2000 So how do i get rid of the green tags, in order to get Vlookup working. Thank U.

THANK YOU!

Dear friends: I have 150 questions in my database in a separate excel sheet. I want 50 random questions out of those 150 questions each time a user opens the excel file. Thank u.

Hello Kris V....try this out: You can use a Pivot Table with Account as a filter field. Then use the Pivot Table Option to "Show Report Filter Pages" which will create a new worksheet for each item in the Account field. No copy/paste. The original data stays untouched. All you need to do is...

Hello Ninjas: I have a table with 20 columns. I hide 2 columns and copy the data to another location. Upon pasting, even the hidden 2 columns r visible. Is there a way that the hidden columns remain hidden..?? Thank u.

Thank u guys. I am now looking at a simple VBA solution like the following. Since i am a novice at VBA; can anybody help complete it. Thank u in advance. select range for each row, if date < today() -30 delete row

How can I change a daily data series into a weekly or monthly series??? Column A contains the dates 1/1/2013, 2/1/2013 and so on. Columns B & C contain the data. Is there a simple Vlookup formula 2 achieve the desired result.???

Thank u, Sir. That was good.