You cannot post messages because only members can post, and you are not currently a member.
Description:
This Group is dedicated to unleash the POWER of MS EXCEL & VBA MACROS,one of the best Programming ever created for Mankind.
It is 100% resistant to spam, serving over 6000 worldwide members. You can win prizes by submitting tips and tricks in the community. Experts including MVPs are active here.
|
|
|
Date format problem
|
| |
Good Evening Excel Gurus,
I have a data in this format 01-01-01, however as soon as I enter them in
the excel sheet,excel picks it up as date and stores it in date format, Is
there any way I can prevent this from happening.
Also how to convert this data back from date format 01/01/2001 to original... more »
|
|
|
Help regarding countif formula
|
| |
Hello,
with reference to the above excel sheet you can see that when a name of the
customer is repeated for the first time then the cycle shown against this
name is correct but when the same name comes another time then the cycle
shown against that name is decreased by one. so i request hereby to help me... more »
|
|
|
Autofill Based on a Changing Column
|
| |
Hi
Any assistance with the following would be most welcome.
I am trying to find some VBA code which will allow me to copy a
formula from an ActiveCell down to the last row in the ActiveCell
column based on the non blank cells in the column to the left of the
ActiveCell column.
For example, if the ActiveCell is equal to C5 and the range B5 to B20... more »
|
|
|
save workbook copy
|
| |
In Excel 2003 is it possible to save a copy
of the workbook to a specific file location,
allow the user to enter the file name by a
prompt but keep the original file open?
The copy is saved and closed in the
designated file location.
|
|
|
VBA Books & Study Material
|
| |
Dear All,
I want to learn VBA. i tried using excel help. but it is very
difficult learn from excel help. kindly provide & suggest some of
books and study material so i can also learn.
Thanks
Mahavir
|
|
|
Hide/Unhide and Print selected sheets
|
| |
Dear All,
I want to create a macro by which I want to print relevant sheet and
want to hide/unhide irrelevant sheets. I want to list out all working
sheet in one sheet and in column next to the name of the worksheet i
want to put Yes/No for hide the sheet. Once i decide the whole sheet
which i want to hide i want to run the macro. e.g.... more »
|
|
|
Pls provide me code here.
|
| |
Dear excel Gurus,
Please find the attached test file and resolve my problem here.
I want to click batten in sheet 1 then user form is pop-up .i will
fill application like name , designation and salary in respective
fields.But I want to save my entry's to Main Database sheet
accordingly. Pls. help me.... more »
|
|
|
Help for Expiry Date with Hijri Date System
|
| |
Hi Gurus ,
I need a conditional formatting for this excel sheet which is supposed to
give me warning for expiry
date of residential permit , but my problem is my windows date & time is
Gregorian & this dates are
in Hijri format.
I need it to warn me a month before expiry date .
Can anyone help me here ?... more »
|
|
|
|
