This is done !!
-Ayush Jain
On Oct 5, 9:54 am, Mahreen Ellahi wrote:
> Kindly unsubscribe me from the group.
>
> Extreme Regards
> Mahreen
--~--~-~--~~~---~--~~
--
Some important link
Hi All
Please provide with a code which can put RGB cell values in colored cells.
Hugs
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutoria
Kindly unsubscribe me from the group.
Extreme Regards
Mahreen
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins dow
dear excel genuises,
may i request your help how to change the default message in excel 2003
status bar? and prevent the user from changing it.
thanks a lot. may god shower you with graces.
dellosa
--~--~-~--~~~---~--~~
---
Hi Dilip,
Thanks a tonn for your kind help.
There is a typo in the second criteria which i send out earlier. Please read
it as under:
For other Customers, I need to follow up after 20*/25/30* calender
days (depending
upon the customer) from a given date (the given date can be today/yesterday
There are many lookups, what kind of information you need to warrant the
lookup function. Please tell us what is your problem precisely. dont make
us guess.
On Sat, Oct 3, 2009 at 12:20 PM, Equity Monk wrote:
> Dear Friends,
>
> I am attaching a portfolio. It is a mf portfolio.
> If you can pls
customer dzip New Customer
proctoandg 10024 procto
procto 10024 procto
procto 10024procto
bambo 13456 bambospecies
bambospecies 13456 bambospecies
barbs 200011
Never mind, I received help elsewhere.
On Oct 2, 11:55 pm, vespid wrote:
> I'm making excel macros for the first time and getting things figured
> out, but I have a few questions:
>
> What code do I use to delete columns that have all empty cells EXCEPT
> the top cell (row 1) that contains any o
Dear Dilip,
I am not as good as you are. So, could you pls modify the Macro to suite
Indian Curreny i.e. Rupees (Rs) and Paisa.
Thanks
On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey wrote:
> Hi Zaheer,
>
> Just answered this one a while ago. Check out and let me know if you
> did'nt find that e
Easier!! Given a sheet with the format I sent, I need to create an
output sheet opened by resource location.
On Oct 3, 3:33 pm, jamesdavey wrote:
> so you mean, for example, you want to add a new resource manually,
> then press a button perhaps to update an output sheet?
>
> On 3 Oct, 12:42, Cec
Sounds good Paul!! Thanks!!
On Oct 3, 4:52 pm, Paul Schreiner wrote:
> Actually, I might be able to help here.
> I'll have to wait until I get back to work on Monday though!
>
> Paul
>
>
> From: Chechu
> To: MS EXCEL AND VBA MACROS
> Sent: Saturday, October 3,
You are welcome!!
Let "Group" know, if you need anyother Excel Keyboard shortcut or Excel
Function shortcut.
Thanks & Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/4/09, janet dickson
customer id customer New customer 10021 pg pg 10021 pgr pg 10022 st pg
10022 dpa pg 10022 dp pg 101223 ac pg 101223 ade pg 10045 adr if i
change the customer ids little bit, i am getting the output as shown above
under the new customer column. Is there something missing in the formula o
hi Dilip
how would i repeat the formula for the rest of the cells in my spreadsheet.
because i do copy and paste+ special+formula, it is gving me value"dp" for
all the cells. dp as you could see is the last value in yr spreadsheet.
Also does this work when there is only one customer id and no dup
Hi Prashant,
Your answer is correct upto an extent but not fully correct because your answer
has a limit of 16 character if you can increase it to 256 or above then it is
ok.
Thanks & Regards
Sandeep
- Original Message -
From: Prashant Bhawar
To: excel-macros@googlegroups.com
S
Thanks a lot for the shortcut, I have been looking for these stuffs
Hugs
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dilip Pandey
Sent: Sunday, October 04, 2009 12:59 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Shortcut t
hi
i here attached solution hope this is right.
On Sat, Oct 3, 2009 at 10:41 PM, Sandeep wrote:
> Reverse a text or number or mixed value entered in a cell using functions
> only not VBA.
>
> e.g.
> Say A1 = ABC351D
>
> Then the answer in cell A2 should be D153BCA
>
> The entered value may be
*Had to create an UDF...see attached file.not sure if it can be done
using formula in one cell.*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Sat, Oct 3, 2009 at 10:41 PM, Sandeep wrote:
> Reverse a text or number or mixed value entered in a cell using functions
> onl
Hi Zaheer,
Just answered this one a while ago. Check out and let me know if you did'nt
find that email. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/2/09, ~ Z A H E E R ~ wrote:
>
> Dear gro
Hi Subs,
Good job. Well drafted query and slightley lenghtly too.
I have given a try in the attached file, assuming that the data would always
be sorted on "Customer Id", as given by you in the scenario. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@g
Hi Zaheer,
Web is filled-up with these types of automation codes, below is one of
them:-
http://www.ozgrid.com/VBA/ValueToWords.htm
Off-course you have to customize the solution at your end as well :- which
is a fare expectation, I believe...!!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B
Prashant, You are always welcome.
Alternatively, Depending on the scenario, you can also use V-lookup & Match
functions - to lookup values from a data range in which respective target
columns can shift to left or right side any time. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobil
Hi Vinod,
You can use an inbuilt function of Excel viz. "Workday" to achive the
required result. Same is explained in the attachment. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/3/09, Vinod
Hi Karthikeyan,
Go to this "group" ' s home page and visit "Files" section. Alternatively,
you can also search web for free e-books. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/3/09, karthike
Hi,
Below is what I generally use:-
To rename a worksheet:- Alt+ O + H + R
To delete a worksheet:- Alt+ E + L
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/3/09, AS it wrote:
>
>
> Hi fr
Hi Prashant,
Problem would be :- you'll have to manually change the "column index
number", if you drag the formula to right side or to down. In my formula,
it will automatically change from 2 to 3 then 4, then 5 and so on.
Hope this solves your query. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B C
Dear group members,
Please help to to write numbers into words with currency name automatically.
for. eg. if i enter "1,250/365" in any cell then formula or code should give
me asnswer in words in any other cell "[Currency Name] Öne Thousand Two
Hundred Fifty & [Currency Name for change] 365/1000
customer id customerNew customer
10021pg pg
10021pgr pg
10022dp dp
10022dpadp
10022
Hi,
Send me the file i will try to solve it. But give me the original file for
getting the correct pattern and exception.
If you can't send the file to this group then send me on
sandymau...@gmail.com.
Regards
Sandeep
- Original Message -
From: "BMWFLYBOY"
To: "MS EXCEL AND VBA MACR
so you mean, for example, you want to add a new resource manually,
then press a button perhaps to update an output sheet?
On 3 Oct, 12:42, Cecilia Chiderski wrote:
> Hi, I need your expertise on this... Example attached. I have a list of
> resources with different locations. There are 3 possibl
Hi,
Please help me in the calculating the follow up date of a a particular
request. The criteria is as under:
- For a particular type of customer, I need to follow up after 10
working days from a given date (the given date can be today/yesterday or a
day earlier) and need to exclude eve
Anybody knows Excel Macro E-books?
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excel
Reverse a text or number or mixed value entered in a cell using functions only
not VBA.
e.g.
Say A1 = ABC351D
Then the answer in cell A2 should be D153BCA
The entered value may be text or number anything but result should be reversed.
Regards
Sandeep
--~--~-~--~~~-
Hi friends,
I want to know Shortcut to rename or Delete the worksheet of any
Workbook
please revert
BR,
AS it
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel
hi Dilip,
u use formula =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfolio!$B$1:B$1)+1,0)
if i use this =VLOOKUP($A:$A,Portfolio!$B:$L,2,0)
then whts the problem ?
On Sat, Oct 3, 2009 at 10:30 PM, prashant bhawar wrote:
> hi Dilip,
>
> u use formula
> =VLOOKUP($A:$A,Portfolio!$B:$L,COUNTA(Portfo
35 matches
Mail list logo
