Re: $$Excel-Macros$$ need help

2011-07-23 Thread Akshay
Thanks to All, It really amazing.. Great With Regards, Akshay On Sat, Jul 23, 2011 at 10:29 AM, Rajan_Verma rajanverma1...@gmail.comwrote: *See the attached File..* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashish koul

$$Excel-Macros$$ MS Excel MCQ Quiz

2011-07-23 Thread XLS S
MS Excel MCQ Quiz 1. You can use the formula pallette to A) format cells containing numbers B) create and edit formula containing functions C) enter assumptions data D) copy a range of cells 2. When a range is selected, how can you activate the previous cell? A) Press the Alt key B)

$$Excel-Macros$$ Global Consulting firm hiring Sr Analyst for Hyderbad Location

2011-07-23 Thread XLS S
*Experience required for the Job:* 2 - 4 years *Annual Salary of the Job:* 1.0 - 6.0 Lacs *Job Location:* Hyderabad *Dear Candidate,* Hi, We have excellent oppurtunity with Global Consulting Firm for Sr Analyst position Looking for candidates with excellent exp in MIS reporting, Excel macros

$$Excel-Macros$$ Linest on non-contiguous arrays

2011-07-23 Thread marston.go...@allstardirectories.com
I have a series of columns that represent candidates 'x' values for a regression. I'd like to be able to create a very simple way of running linest scenarios on each independent permutation w/o having to rearrange all of the columns a bunch of different times. Example: Column A-J are the

$$Excel-Macros$$ LINEST

2011-07-23 Thread marston.go...@allstardirectories.com
I'm trying to utilize a series of data to execute multiple Linests. I have 10 columns of data of equal length. The first 9 columns represent 'x-value' candidates The 10th column represents 'y-value' I'd like to create linests that utilize each potential unique variation of each of the first 9

$$Excel-Macros$$ job

2011-07-23 Thread ashish koul
Hi! Reference to your profile in Job Portal, we have openings for MIS Automation Analyst, with European Investment Bank ::: Work Location: Hyderabad. Send your update profile to bfsi.job...@gmail.com along with following details. ***Checklist Is Mandatory 1. Have you Read the Job

$$Excel-Macros$$ Forum rules : Please adhere else you will be BANNED

2011-07-23 Thread Ayush Jain
Hello everyone, Please adhere to below rules of the forum. You will be banned without warning on non compliance. Till date 806 members are banned in group, This is the reason the group is spam free. *Please read and adhere to these simple rules!* * 1. Use concise, accurate thread titles.

RE: $$Excel-Macros$$ adding adjacent (contagious) cells only

2011-07-23 Thread Dave Bonallack
Hi Haseeb, I of course haven't seen every answer to every question on this forum, but your formula solution to finding the number of groups is one of the best I've seen. Regards - Dave. Date: Thu, 21 Jul 2011 09:11:12 -0700 From: haseeb.avarak...@gmail.com To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Forum rules : Please adhere else you will be BANNED

2011-07-23 Thread XLS S
Dear Ayush, Thanks for sharing rule's, Is it possible that read all the rules and regulation before join from? specially for new member Because i am also new member... On Sat, Jul 23, 2011 at 4:50 PM, Ayush Jain jainayus...@gmail.com wrote: Hello everyone, Please adhere to

$$Excel-Macros$$ Job in Delhi

2011-07-23 Thread Sant Ram
*Experience required for the Job:* 2 - 4 years *Annual Salary of the Job:* 2.0 - 3.0 Lacs *Job Location:* Delhi/NCR *Dear Candidate,* Hi, We have an urgent requirement of MIS/Sr MIS Executive at our head office at Okhla. Company profile: CPM India is leading organization in sales marketing

RE: $$Excel-Macros$$ LINEST

2011-07-23 Thread Rajan_Verma
Hi Do You want this , My Maths is not so good but I think it will generate 9^9 Unique Id Number for you. Sub ss() For One = 1 To 9 For Two = 1 To 9 For three = 1 To 9 For Four = 1 To 9 For Five = 1 To 9 For Six = 1 To 9

Re: $$Excel-Macros$$ Forum rules : Please adhere else you will be BANNED

2011-07-23 Thread Ayush Jain
There is no feature in google groups to send an email to new users. The link is available on the top of the page for new users. Regards Ayush Jain On Sat, Jul 23, 2011 at 8:23 PM, XLS S xlst...@gmail.com wrote: Dear Ayush, Thanks for sharing rule's, Is it possible that read all the rules

Re: $$Excel-Macros$$ Unlocking locked sheets/workbooks or VBA projects!!!

2011-07-23 Thread crazybond
Experts, Would one of you be so kind to advise on the subjected question? Regards, On Fri, Jul 22, 2011 at 2:17 AM, crazybond crazybond...@gmail.com wrote: Experts, In order to unlock locked sheets/workbooks or VBA project, which program or codes would you suggest. Regards --

$$Excel-Macros$$ vba for loops -beginner

2011-07-23 Thread netuser501
Hi The question worksheets is filled with data on 5 rows and 3 columns. I'd like to have this data stored in an Array. For testing purpose, I want to test if the loop is reading the data with an integer tmp that should return the number of cells filled in with data. Set wkb = ThisWorkbook Set

$$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

2011-07-23 Thread Ruchi B
All, Have a excel workbook with around 15 tabs ..each of tab has multiple pivots referring to different sets of data. All the pivots refer to 4 data sets in all .What is the best way of refreshing these multiple Pivots in different tabs at one go? Regards, Ruchi --

Re: $$Excel-Macros$$ Login Logout Report Help Required...

2011-07-23 Thread Venkatesan c
It's Working Daniel ...Thanks a lot. *Best Regards,* *Venkat* On Sat, Jul 23, 2011 at 8:19 PM, Daniel dcolarde...@free.fr wrote: Hi, ** ** Run the following macro : ** ** Sub LoginLogout() Dim c As Range Range([L3], Cells(Rows.Count,

Re: $$Excel-Macros$$ Copy text from Word and paste into Excel

2011-07-23 Thread dkelb
How can I attach!? Sorry -- I'm new. On Jul 22, 11:50 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Attached your word document. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Darin Kelberlau Sent: Saturday, July 23, 2011 9:04 AM To:

Re: $$Excel-Macros$$ Help with Refreshing Multiple Pivots on different sheets

2011-07-23 Thread ashish koul
do you want to change the source data or just refresh change calculations to automatic and then click on refresh all On Sat, Jul 23, 2011 at 10:36 PM, Ruchi B ruchi.ben...@gmail.com wrote: All, Have a excel workbook with around 15 tabs ..each of tab has multiple pivots referring to

Re: $$Excel-Macros$$ Copy text from Word and paste into Excel

2011-07-23 Thread ashish koul
hi copy all the content of the document and paste i t in col a of sheet 1 then run this macro Option Compare Text Sub test() Dim i As Long j = 1 For i = 1 To Range(a65356).End(xlUp).Row If Left(Cells(i, 1).Value, 7) = School: Then j = j + 1 Cells(j, 8).Value = Right(Cells(i, 1).Value,