Hi Huzaifa,
Yes, it is possible. It is similar as you subtract number in Excel, after
that you have to change the cell format to "YY-MM-DD" format.
Alternatively, you can also use DATEDIF function, to get the difference as
per your choice i.e. months, completed months, years etc.
--
DILIP KUMAR
Hi Hanumant,
If the users used to save that workbook then you can identify this by "Date
modified"- because here you can see data and time when the workbook was last
modified.
If the users only open the workbook and closes without saving changes, then
you can include a macro which will send an au
Hi Subs,
Just answerd this one a minute ago.
Suggestion:- Do not post the same query as a seperate posting.
Alternatively, you can send reminders(s).
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 11006
Hi Subs,
Before approaching to step 4, look at the attached file. I have formulated
the sorting to be done. Now Sort the entire data by column "Sort" - in
descending order and you will get the desired result.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gm
I have an Excel application that enables the user to export an Exccel
chart directly into PowerPoint. The macro to do this works fine
provided PowerPoint was not already open.
I am trying to figure the VB code so when the application opens it
automatically closes PowerPoint - if in fact PowerPoi
if i want to fill in a number or a forumla for rest of the cells in a
column , is there a short cut to do that or the only way is to pull in
the mouse pointer?pls help
--~--~-~--~~~---~--~~
---
Using Microsoft Office Excel 2007. I am a novice Excel user and get a
little lost talking the VBA language. Here is my example:
I have a couple of buttons with Macros in the first couple of rows/
columns in my spreadsheet.
I have added the Data Form icon to top bar, as mentioned at
http://www.h
You are describing exactly what I had proposed. Should be
straightforward to implement.
Have fun,
Rolf
On Oct 8, 7:45 am, chinmay kamat wrote:
> Thank you sir, but unfortunately this does not solve the problem.
>
> The data is in the following format (example):
>
> For purchases:
> Date
Thank you for your suggestions, I took your advice and made the
changes - but I still get the same results.
I've burned too much time trying to figure this out so I simply put in
a button which prompts the user to click to return to the menu (UF1).
Thank you again for taking the time to repspond
Thank you for your suggestions, I took your advice and made the
changes - but I still get the same results.
I've burned too much time trying to figure this out so I simply put in
a button which prompts the user to click to return to the menu (UF1).
Thank you again for taking the time to repspond
Hi Subs,
After doing the subtotal using the trick which I mentioned earlier, follow
below steps:-
1) Copy - paste as values all data
2) Remove Subotal
3) Remove last row of "Grand total"
4) Now sort the data as you do in normal sort.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.)
Thank you sir, but unfortunately this does not solve the problem.
The data is in the following format (example):
For purchases:
Date Quantity Amount Rate
01/04/08 150/- 85050/-567/-
05/04/08 100/- 61000/-610
Hi Vinod,
Had not get enough time to work on this, but some how managed and revised
the template as per your enhanced criteria. Same is attached. Thanks.
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 1
Hi Mctabish,
Define header to your data and simply create a pivot table from that.
PhoneID on Row, function on Column and function on Data.
You will get a table as below.
Count of Function
Function
Model
Call Forwarding
Call Waiting
Caller ID
Speed Dial
Voice Ma
Hi All,
Apologies if this issue has been duplicated as it took a little bit of
a loopy on me when i tried to submit it last time and appeared to log
me out.
Anyway back to the question in hand, i am developing a macro that will
allow me (or the user) to select an xml file, import it into a
workb
Hi friends
We know that there are loads of softwares available to crack VBA
passwords.
But can i convert some part of my VBA code to a *.dll file and use? (I
guess it should be a bit harder to crack)
I have worked with excel for 2 years and have some programming
knowledge but I am nowhere near
Are you sure the ExitApp macro you placed in your workbook Rpt1.xls
actually works without error? It seems to me that the UserForm UF1 in
that context...
Anyhow I think you can accomplish what you are trying to do simply by
placing the following event handler into the ThisWorkbook VBA module
of y
You should set a breakpoint and
try to step through your macro to see what's going on.
Which file has the ExitApp macro?
Is it in the Rpt1.xls file?
If it is, then once the activework.close line is executed,
the UF1.Show line is no longer there to execute!
also,
Once the Rpt1.xls file closes, Ex
I just uploaded a file called PhoneFeatures.zip into the files area.
However, the Excel file is an Excel2007 file.
What version are you using?
Paul
On Oct 8, 2:03 am, Mog Obahor wrote:
> Hey Paul
>
> Good work on the Phone number exercise. I was wondering if you don't mind
> sharing the dummy
You could use the DATEDIF function (see e.g.
http://www.cpearson.com/excel/datedif.aspx).
Let's assume that your purchase date is in cell A2 and you sell date
in cell B2. The formula =DATEDIF(A2,B2,"d") returns the number of days
between the two dates.
One way to use this function for your scena
It seems that the code you posted is dealing with only one of the two
year columns you mentioned in your post. Give this code a try (after
modifying the constant COL2 to match the range for the second year
column) and see whether it accomplishes what you would like to see
happening:
Const COL1 As
hello Dilip,
I found the answer, but i dose not match my requirements. and dont knw even
"A" of coding. So Plz help me.
i need the answer in following format (1,250.365)
*Kuwaiti Dinars One Thousand Two Hundred Fifty & Fils 365/1000 Only*
**
**
Regards,
ZAHEER
On Fri, Oct 2, 2009 at 4:20 PM, ~
Hello friends,
I'm interested in using excel to do calculation for gains/losses in
shares.
As per law, there are 3 kinds of transactions which can be entered
into in shares. The types are determined on the basis of the period of
holding of each share by using FIFO method. FIFO method assumes tha
Hey Paul
Good work on the Phone number exercise. I was wondering if you don't mind
sharing the dummy *.txt file you created to test the program and also if you
could send the excel spreadsheet with the VBA code where you implemented
it. I will like to study the methodology or your approach. It
Sandeep I don't quite understand your problem, could you please restate it
clearly.
thanks
Mog
On Wed, Oct 7, 2009 at 9:36 AM, Sandeep wrote:
>
>
> - Original Message -
> *From:* G. Ram
> *To:* excel-macros@googlegroups.com
> *Sent:* Saturday, October 03, 2009 8:20 AM
> *Subject:* $$Ex
25 matches
Mail list logo
