Hellow friends
I am awaiting your reply for this my query.
Thanks
On Fri, Oct 16, 2009 at 3:36 PM, big smile wrote:
> HAPPY DIWALI & NEW YEAR TO ALL OUR EXCEL GURU’S & FRIENDS
>
>
>
>
>
> Attached please find the Excel –tips –Query No.3 File
>
>
>
> In Sheet 1 – All the details
Hellow Sir / Friends, - & Dilip Pandeyji
Thanks for giving the answer to my query. & advice for keep smiling,
I will be grateful to you if i get the answer to this query by keeping excel
2007 version
as there are lot of difference to excel 2003 version. [ if possible ]
1] in Excel 2007- in F
Hi Friends,
I m facing a problem while using Auto filter in Excel 2007
When i use filter and copy the data from 1 sheet to another sheet the hidden
cell are also copy from 1 to another sheet.
Please help to solve this
--
With Love,
Mahesh Bisht
--~--~-~--~~~---
Hi All!!!
Does anyone have any good examples of how I can use the MYEXTRACT
function as part of a macro and not just as a function?
I'm trying to extract a word or phrase found somewhere in column A
with a string found in column somwhere in column "B". In my true use
of the function, I have 12,0
Hi ALL
In a excel sheet, I want to trigger an event everyday when time exceeds
10 AM.
Is it possible to display on 20th October 2009 in a cell 20-Oct-2009
10:00 AM,
and when date changes to 21st October 2009 then it should automatically
change to 21-Oct-2009 10:00 AM
Thanks in advance
Regards
Found the solutions by importing data into SQL sever. and using T- SQL
LIKE clause.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and T
Hello, again.
I have a workbook which creates a new worksheet each day. When the
worksheet is completed for the day, it is then saved as a new
workbook. The original workbook is set to reference an xla add-in that
I made but the newly created workbook doesn't have the reference.
Can someone plea
Hi Anil
Just answered this few seconds ago...!!
Please let me know if you did'nt find my response. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/14/09, Anil Saxena wrote:
>
> Pls help me.
>
>
Hi All Champs,
I have a spreadsheet where in every month some customers are being added per
client, now some clients have left during some month, my problem is I am not
able to get the net customers every month after deducting the customers who
have left. lets for simplicity sake think of clients
Hi Hemant,
I dont need False status, I want latest status available based on latest
date. The result should be cancelled.
Regards,
VR
On Fri, Oct 16, 2009 at 9:58 PM, Hemant Hegde wrote:
> Hi friend
>
>
> I have tried to solve. Please find the attachment
>
>
> Happy Deepavali to all
>
> Hemant Heg
Alex, You are always welcome...!!
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/19/09, Alexander Cargill wrote:
>
> Hey hey thanks very much J
>
>
>
> alex
>
>
>
> *From:* Dilip Pandey [
Hi Alexander,
Assign below code to the button:-
Sub dkp()
Application.ScreenUpdating = False
Range("D:D").Select
ActiveCell.End(xlDown).Select
On Error GoTo dk:
For i = 1 To 65536
Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Find(What:=""
Hi BigSmile - Keep Smiling:-
Below are the answers to your queries (using Excel 2003):-
1) Yes, you can delete that name. Go to Insert ->Name-> select the name and
press delete. Change of name is not allowed, but Yes you can make a copy of
that name and rename that as per your choice
2) Yes, Yo
Hi Karthik,
Check if the data which you want to paste is fulfilling the "data
validation" criteria(s). Copy that data and paste special values somewhere
and check the data which you are going to paste if that is matching up with
the cirteria as per text and format etc. OR not.
Best Regards,
--
Hi Aligah,
Just answered this one a minute ago.
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/13/09, Aligahk06 wrote:
>
> Please assist me in attached file
>
>
>
> Rgds,
> Aligahk06
>
>
Hi Aligah,
Just answered this one, publishing the same for you once again.
Two ways:-
1) If the formulae contains links from other workbooks, then "Break Links"
and you are done.
2) If the formulae contains links and references from same workbook then
you have to be tricky as copy and pasting i
Hi Aligah,
Two ways:-
1) If the formulae contains links from other workbooks, then "Break Links"
and you are done.
2) If the formulae contains links and references from same workbook then
you have to be tricky as copy and pasting in filterd data is not allowed if
they are on different rows altog
Hi Anish,
Open the xla file and *.xla should be visible if you press Alt + F11 and
view under projects.
After opening it under project explorer, you can then dig into it and do the
R&D there, provided the project is not password protected. Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Hello Experts...
Could anyone please tell meis is possible to dig in a *.xla file...I
mean if anyone created any Macro and converted it to *.xlaDo we have any
way to Dig into the codes in tht XLA file???
Please reply on this if it is possible
Cheers!!
ANISH
--~--~-~--~-
19 matches
Mail list logo