Hi Anand,
I would need the test for recruitment purpose. we are looking a highly
analytical person in our team and too good with excel skills.
Therefore , would need the test including some macro questions , good use of
excel functions / logical conditions. ( in short... advance excel test and
no
try this
http://www.visualbasic.happycodings.com/Applications-VBA/code4.html
On Sun, Jul 10, 2011 at 9:28 AM, Financeguy wrote:
> Hi All,
>
> I'm trying to generate a list of binary combinations as follows:
>
> cell A1: 0
> cell A2: 1
>
> cell A3: 7
>
>
> I'm requesting help to create the follo
Great Ashish,
*You are the master of your own destiny!!!*
**
*Thanks*
**
*Prabhu*
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2
Hi All,
I'm trying to generate a list of binary combinations as follows:
cell A1: 0
cell A2: 1
cell A3: 7
I'm requesting help to create the following output in separate columns using
VBA:
0 0 0 0 0 0 1
0 0 0 0 0 1 0
0 0 0 0 1 0 0
and so on.. for a total of 2 ^ 7 times in columns A throu
Hi Navneet,
If you could elaborate the purpose of this test it would be easier to
generate a test. For example is this test for the purpose of
recruitment? Do you plan to recruit MIS executives, or data entry
operators or senior data analysts, or designers of dashboards,
templates. Depending upon
at the top of code
'declare s as worksheet
Dim s As Worksheet
Set s = ActiveSheet
replace Sheets("BASE") with s in code with find and replace
note before running the macro select the data sheet
On Sun, Jul 10, 2011 at 12:34 AM, Susan wrote:
> Couldn’t you just edit the sheet name “BASE” to
Couldn’t you just edit the sheet name “BASE” to the new sheet name, from the
VBA screen?
Or
See this link on how to copy macros to other worksheets.
http://office.microsoft.com/en-us/excel-help/copy-a-macro-module-to-another-
workbook-HP010014116.aspx
~S
From: excel-macros@googlegrou
Hi Ashish,
Thanks, It is working prefect!
A small request, It is working only the data sheet name is "BASE"
Can you help me if the name of the sheet is different, then how to use this
macro. Because same workbook am adding the data on daily basis.
Kindly do the needful.
Regards,
Prabhu
--
hay Thanks Daneil.
On Sat, Jul 9, 2011 at 5:53 PM, Daniel wrote:
> There is no « TB17 » textbox and that’s why you get an error.
>
> ** **
>
> Regards.
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De
Hi ,
thanks for your reply.
u will not believe it but i used the same code on test file and its working
fine.
so i am not sure if anything is wrong with the expansion code.
1 more thing i jus remembered.
when the range is expanded and wen i used select range it select right range
BUT
when i p
Hey how can i attach sample files, which button to click? as i dont
see any button with browse or attach. please help
On Jul 9, 11:31 am, ashish koul wrote:
> check the attachment see if it helps
>
> On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE <
>
>
>
>
>
>
>
>
>
> pradeepkumar...@gmail
Hey thanks for the formulae, but i want this with a vba code, as i have
send to my customers, i cannot tell them to use formulaes they want
everything in "ALT+F8" format
On Sat, Jul 9, 2011 at 12:01 PM, ashish koul wrote:
> check the attachment see if it helps
>
>
> On Sat, Jul 9, 2011 at 9:56
Hi Hanumant
It is interesting..
I am assuming that code first changes the range for the name and then
the same is getting used. Try changing the order or refresh
(Calculate) the sheet.
If possible, share the test file.
Best Regards,
DILIPandey
On 7/9/11, hanumant shinde wrote:
> Hi friends,
>
There is no « TB17 » textbox and that’s why you get an error.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : samedi 9 juillet 2011 13:01
À : excel-macros@googlegroups.com; dcolarde...@free.fr
Objet : Re: $$Excel-
Hi Vinod,
Please share the test file.
Regards,
DILIPandey
On 7/8/11, vinod rao wrote:
> Hi,
> I have put a pivot table and i need to get Gross% starting from 0% and above
> data listed in pivot. Can i know how to get in pivot by by adding formula?
> My data has both -ve and +v % but what i need
Hi friends,
i have a file in which there are 2 sheets. sheet A and B. i am giving name
ranges in sheet B as below.
A1:A20 - "Range1"
B1:B20 - "Range2"
C1:C20 - "Range3"
D1:D20 - "Range4"
these name ranges are used in Sheer A.for data validation
programatically i am increasing these ranges
Hi,
Can somebody send me the toughtest excel( Excel 2003 or 2010) test asap.
No. of questions doesn't matter.
Will be a great help.
Thanks!
Navneet
--
--
Some important links for excel users:
1. Follow us on TWITT
Dear Friend,
Can you please send a formula how to use a FIFO method in MS ACCESS?
Waiting for your reply
Thanking you
Sanjib
On Thu, Jul 7, 2011 at 11:50 AM, ankur wrote:
> * my pleasure
> *
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the
Mr Santhosh,
your formula put 1 in A2,1 IN A3,2 IN A4,AGAIN 1 IN A5,3 IN A6.
i.e., REQUIRED NUMBERING FILLED IN EVEN CELLS, AND ODD CELLS HAVE 1
AM I RIGHT?
R.KARUNANITHI
--- On Sat, 7/9/11, santosh bahuguna wrote:
From: santosh bahuguna
Subject: Re: $$Excel-Macros$$ Numbering
To: excel-mac
“Me” represents the object containing the code ; so, in this case, « me » is
equivalent to “Userform2”. Can you post your workbook ?
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de shariq khan
Envoyé : samedi 9 juillet 2011 00:32
À : excel-macr
20 matches
Mail list logo
