Hi Maddy,
Your query is quite simple and I wonder if you know VBA, Vlookup and
every other thing then where did you stucked up?
Since you've provided detailed info in algorithmic format, I've tried
to solve your query. If this doesn't suffice you then you need to
carefully look into your logic pr
Harmeet,
I am able to do sort & do a lookup and I can also write VBA code for
the sort & lookup functions. However, my problem is the macro should
sort the names in Valuation tab as per their order in PV tab,
irrespective of their current location.
Request you to go through my spreadsheet (espec
I request everyone who tries to answer my request, to go through my
attached spreadsheet especially For Your Information Tab COMPLETELY
and CAREFULLY.
YET NOW NO ONE HAS PROVIDED ME CORRECT SOLUTION. I am wondering
whether anyone correctly understand my issue or not. :(
On Mar 23, 12:18 pm, Dili
Rightly said Harmeet..!!
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Mar 23, 2009 at 12:42 PM, Harmeet Singh wrote:
> Hi Maddy,
>
> Attched file is updated by Sort function.
>
> Trust me for one thi
Hello Harmeet,
The issue here is to sort the data in valuation tab as per the data in
PV tab. I think formulae can not be helpful in sorting the data.
Therefore, could anyone write a macro for this???
Please refer to For Your Information tab in my first post below:
Here is the points for your q
I found no solution for sorting the names in Valuation tab as per PV
tab. ???
On Mar 22, 5:45 pm, Harmeet Singh wrote:
> Hi,
>
> Due to time constraint couldn't write VBA macro.
> Sending you updated file, it has formulas and giving required results. As
> per me for this requirements formulas wo
Sorry... Missed to attach the spreadsheet... Here you go...!!!
Maddy - ma10ku...@gmail.com
On Sun, Mar 22, 2009 at 3:22 AM, Maddy wrote:
> Hello Everyone,
>
> Could anyone write an excel macro to do the below tasks (in Excel
> 2003) ?
>
> I have a "complete" set of names in a sheet named PV.
