I have a some query regarding the vlookup can somebody help
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
Base file: this file has 3 columns which has
CustomerLE Cost Center
AUG0001 SDFV445858
USA0001 JHNE652147
ZMA0001 NMVE321745
Actual file: I have same 3 columns, I want a macro which has to
CONCATENATE all the 3 columns and do a vlookup to check the
combination, if the
please shoot your query
On Sat, Jul 9, 2011 at 9:43 AM, PRADEEP KUMAR KOKNE
pradeepkumar...@gmail.com wrote:
I have a some query regarding the vlookup can somebody help
--
--
Some important links for excel
Dear Rajan_Verma,
Its working properly , Thank you very much for supporting me.
Best Regards
Syed Azeem Quraishi
Engineering Dept. H5-Project,UAE
P Before printing, think about the environment.
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On
check the attachment see if it helps
On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE
pradeepkumar...@gmail.com wrote:
Base file: this file has 3 columns which has
CustomerLE Cost Center
AUG0001 SDFV445858
USA0001 JHNE652147
ZMA0001 NMVE321745
Actual file:
“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
À :
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 ankurpande...@gmail.com wrote:
* my pleasure
*
Have A Nice Time Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
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 santoshbahug...@gmail.com wrote:
From: santosh bahuguna santoshbahug...@gmail.com
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
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 by 10
Hi Vinod,
Please share the test file.
Regards,
DILIPandey
On 7/8/11, vinod rao vinod.ma...@gmail.com 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
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:
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 arsfan2...@yahoo.co.in
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 koul.ash...@gmail.com wrote:
check the attachment see if it helps
On Sat, Jul
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 koul.ash...@gmail.com wrote:
check the attachment see if it helps
On Sat, Jul 9, 2011 at 9:56 AM, PRADEEP KUMAR KOKNE
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
hay Thanks Daneil.
On Sat, Jul 9, 2011 at 5:53 PM, Daniel dcolarde...@free.fr wrote:
There is no « TB17 » textbox and that’s why you get an error.
** **
Regards.
Daniel
** **
*De :* excel-macros@googlegroups.com
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
--
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:
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 sunni...@gmail.com wrote:
Couldn’t you just edit the sheet
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
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
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
try this
http://www.visualbasic.happycodings.com/Applications-VBA/code4.html
On Sun, Jul 10, 2011 at 9:28 AM, Financeguy velocity...@gmail.com 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
24 matches
Mail list logo