using vlookup and requirement is pick data from other sheet.
I have data in 10 column and first column is unique column.i want pick only
limited column like 4 6 9 column.and requirement is only one time use
vlookup formula and pick all data in other sheet by unique column.
--
Are you
Hi Manish,
Will you please elobrate with example data.
On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal manish88jais...@gmail.comwrote:
using vlookup and requirement is pick data from other sheet.
I have data in 10 column and first column is unique column.i want pick
only limited column like
Share your workbook plz
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Thu, Mar 6, 2014 at 3:55 PM, Dileep Kumar deepuk...@gmail.com wrote:
Hi Manish,
Will you please elobrate with example data.
On Thu, Mar 6, 2014 at 3:52 PM, manish jaiswal
Cust#Sold to Cust#Sold to - Name Comm# Inv#No Invoice Date Item Code
Business 7000666325 SANDEEP ENTERPRISES 6562501469 01.03.2014 A39 HD Karbonn
Tab 7000666218 B.R. ENTERPRISES 6580015382 01.03.2014 A34 HD STAR Karbonn
Tab 7000663581 SHREENATHJI DISTRIBUTOR 6675032273 01.03.2014 A37 HD
On Thursday, March 6, 2014 4:03:30 PM UTC+5:30, manish jaiswal wrote:
Cust#Sold to Cust#Sold to - Name Comm# Inv#No Invoice Date Item Code
Business 7000666325 SANDEEP ENTERPRISES 6562501469 01.03.2014 A39 HD Karbonn
Tab 7000666218 B.R. ENTERPRISES 6580015382 01.03.2014 A34 HD STAR
Try this
=VLOOKUP($I1,$A$1:$F$9,COLUMN(A$1),0)
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Thu, Mar 6, 2014 at 4:05 PM, manish jaiswal manish88jais...@gmail.comwrote:
On Thursday, March 6, 2014 4:03:30 PM UTC+5:30, manish jaiswal wrote:
Cust#Sold to
=VLOOKUP($I2,$A$1:$F$9,MATCH(L$1,$A$1:$F$1,0),0)
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Thu, Mar 6, 2014 at 4:21 PM, mrExcel4u mr.exce...@gmail.com wrote:
Try this
=VLOOKUP($I1,$A$1:$F$9,COLUMN(A$1),0)
Thanks regards,
www.MrExcel4U.com
The problem seemt to be:
in LinInterpolate, xRange and yRange are declared as variant
when you pass xRange as Range(B3:B44).Value,
you're passing an ARRAY, so xRange becomes an Array variable.
an Array variable doesn't HAVE the property of: xRange.Cells.Count
because xRange (as an Array)
Como vincular uma célula entre duas planilhas mantendo o Hiperlink?
Tenho duas planilhas, onde vinculei as células para alterarem
automaticamente, porém, quando insiro um hiperlink na planilha original,
ela não se altera na outra planilha que deveria ser atualizada.
Copiando e colando, até
I have two worksheets and I linked the cells to change automatically, but
when I insert a hyperlink in the cell of the original worksheet, it does
not change the other worksheet that should be updated.
Copying and pasting the cells, it works, but when i update the hiperlink,
it doesn't
So, I
I take it you're using a Change event to update the th second worksheet?
If that's the case, the reason is because the change event is triggered by the
content of the cell, not how it's displayed.
For example:
if you have a date in a cell like: 06-Mar-2014
The cell ACTUALLY contains a
Imam veliko txt. datoteke, ki jih želite samodejno uvozijo preko VBA koda
tekstovan
datoteke je vedno enak aritetura potrebujejo le nekateri podatki v teh dveh
vrstah, kar je rdeča samo želijo te podatke * Izbrano PCB: C: \ SmartSM \ \
PCB 2013/04/02 KL.SENSOR . odločijo * izbrani datum:
Hi Expert,
I need your help. how to show cell value as tool tip when mouse over that
cell.
--
Thanks and Regards, Rp.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Hi Expert,
Please find file in attachment
--
Thanks and Regards, Rp.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
In B2 -
=RIGHT(A2,6)
and drag down.
HTH
On Fri, Mar 7, 2014 at 11:57 AM, Rupesh Patil patil.rupesh1...@gmail.comwrote:
Hi Expert,
Please find file in attachment
--
Thanks and Regards, Rp.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
Hi Rupesh,
PFA
Thanks
Ashish
On 7 March 2014 11:57, Rupesh Patil patil.rupesh1...@gmail.com wrote:
Hi Expert,
Please find file in attachment
--
Thanks and Regards, Rp.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Join official
Thanks your quick reply, but I want cut last 6 characters from column 'A'
and paste it to columnB
On Fri, Mar 7, 2014 at 12:08 PM, Abhishek Jain abhishek@gmail.comwrote:
In B2 -
=RIGHT(A2,6)
and drag down.
HTH
On Fri, Mar 7, 2014 at 11:57 AM, Rupesh Patil
Thanks Ashish your quick reply, but I want cut last 6 characters from
column 'A' and paste it to columnB
On Fri, Mar 7, 2014 at 12:12 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Hi Rupesh,
PFA
Thanks
Ashish
On 7 March 2014 11:57, Rupesh Patil patil.rupesh1...@gmail.com wrote:
Hi Rupesh, then go with abhishek's formula.
Thanks
Ashish
On 7 March 2014 12:19, Rupesh Patil patil.rupesh1...@gmail.com wrote:
Thanks your quick reply, but I want cut last 6 characters from column 'A'
and paste it to columnB
On Fri, Mar 7, 2014 at 12:08 PM, Abhishek Jain
Hi Ashish,
that is not solution for my problem.
thanks your valuable time
On Fri, Mar 7, 2014 at 12:23 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Hi Rupesh, then go with abhishek's formula.
Thanks
Ashish
On 7 March 2014 12:19, Rupesh Patil patil.rupesh1...@gmail.com wrote:
Dear Rupesh,
Plz see the attached.
HTH
Abhishek
On Fri, Mar 7, 2014 at 12:36 PM, Rupesh Patil patil.rupesh1...@gmail.comwrote:
Hi Ashish,
that is not solution for my problem.
thanks your valuable time
On Fri, Mar 7, 2014 at 12:23 PM, Ashish Kumar
kumar.ashish...@gmail.comwrote:
Hi
Dear All,
Good Afternoon,
I have one query .
Can we change the Name Range with help of VBA
for example below are the name range in my excel file I have to extend
the range by 2...i.e 85000.
if it is possible ..Kindly provide the code for the same.
Abhijit_ =Details!$AJ$1:$AJ$65000
Glad it helped.
Rgds, Abhishek
On Fri, Mar 7, 2014 at 12:51 PM, Rupesh Patil patil.rupesh1...@gmail.comwrote:
Dear Abhishek,
Thanks Abhishek, this is exactly, I want.
Thanks again.
On Fri, Mar 7, 2014 at 12:43 PM, Abhishek Jain abhishek@gmail.comwrote:
Dear Rupesh,
Plz see the
23 matches
Mail list logo