Dear All Experts
I here attached Hyperlink sheet in which my requirement is completed.But I
ask to all experts can anybody provide me VBA code for hyperlink.Solution
required like in sheet.when I click name & click button then select that
table automatically.
Thanks
Regards
Amar
--
Are you =EXP(E
Yes Sir,
If you see the attached sheet, there one button is there, please click
on that and go to second sheet. you will find that every time the datas
are shifting down
-Chaya
On Tue, Mar 12, 2013 at 12:02 PM, Abhishek Jain wrote:
> Can you also provide a sample output?
>
>
> On Tue, Mar 1
Can you also provide a sample output?
On Tue, Mar 12, 2013 at 11:37 AM, Chaya wrote:
> Dear Experts,
>
> Once more help please, i am a new learner in macros, i love it. right now
> i am learning by only recording the macros in excel. even i don't know how
> to declare vaue and solve the query.
Sir, Please suggest me on which format i will select, please see below
image :
[image: Inline image 1]
On Tue, Mar 12, 2013 at 11:47 AM, The Viper wrote:
> you should choose .xlsx format while saving your workbook
>
>
> On Tue, Mar 12, 2013 at 11:35 AM, Chaya wrote:
>
>> Sir, i am using Ms off
8.33% of what ?
One should not suppose that all people have similar understanding of
problem as the person who is asking for a solution. Last time also, you
missed several things. Please give complete explanation.
PS: I could not understand anything from that sample calculation.
On Tue, Mar 12,
you should choose .xlsx format while saving your workbook
On Tue, Mar 12, 2013 at 11:35 AM, Chaya wrote:
> Sir, i am using Ms office 2010.
>
> -Chaya
>
>
> On Tue, Mar 12, 2013 at 11:28 AM, The Viper wrote:
>
>> what version of excel are you using?
>> Ëxcel 97-2003 has the capability of holding
On Monday, March 11, 2013 5:42:36 PM UTC+5:30, shrini wrote:
>
> Dear Prabhakar
> Please clear Following things
> 1.What is full year (how much Bonus wage is full year) - Full year means
> FY (from 01.04.2012 to 31.03.2013)
>
> 2.In body of mail u r showing greater than 1 but in Sheet u r
Sir, i am using Ms office 2010.
-Chaya
On Tue, Mar 12, 2013 at 11:28 AM, The Viper wrote:
> what version of excel are you using?
> Ëxcel 97-2003 has the capability of holding maximum 65536 rows.
>
>
> On Tue, Mar 12, 2013 at 11:24 AM, Chaya wrote:
>
>> Sir,
>>
>>How to View then, Please ad
what version of excel are you using?
Ëxcel 97-2003 has the capability of holding maximum 65536 rows.
On Tue, Mar 12, 2013 at 11:24 AM, Chaya wrote:
> Sir,
>
>How to View then, Please advice me ? what is xlsx format, you mean
> Ëxcel 97-2003 Workbook format" ? i already did save as than, ple
Sir,
How to View then, Please advice me ? what is xlsx format, you mean Ëxcel
97-2003 Workbook format" ? i already did save as than, please suggest
experts..
Thanks,
Chaya
On Tue, Mar 12, 2013 at 11:19 AM, The Viper wrote:
> you cannot view more than 65536 rows in prior versions of excel.
>
you cannot view more than 65536 rows in prior versions of excel.
if your excel version is 2007 or above, choose .xlsx file format while
saving your workbook.
On Tue, Mar 12, 2013 at 11:05 AM, Chaya wrote:
> Dear Experts,
>
> I have a data base which contains more than 1 lacs rows
Dear Experts,
I have a data base which contains more than 1 lacs rows, When
i copy and paste to a new work book, that time all the rows was showing in
the sheet, after that i save and close it. After while i open the work book
which contains the data base. i am shock by seeing the dat
Dear Abhi,
i missed to inform
8.33% with a maxim cap of 3500rs as bonus and for salary less than 10k.
On Monday, March 11, 2013 6:10:55 PM UTC+5:30, Abhi wrote:
> Paste in H2 and drag down.
>
> =IF(AND(C2<41000,G2<=1),3500,IF(G2>1,0,((41365-C2)*3500)/365))
>
> This is based on foll
Dear Rahim
Pl specify your problem little bit more.
Warm Regards,
Gawli Anil
On Mon, Mar 11, 2013 at 11:29 PM, Rahim Sharieff
wrote:
> Hi,
>
> Please find the attached workbook.
>
> 1. There are two tabs "Test 1" and "Test 2"
> 2. The Header row is in row 5 and the data starts from row 6 onwa
Hi,
Please find the attached workbook.
1. There are two tabs "Test 1" and "Test 2"
2. The Header row is in row 5 and the data starts from row 6 onwards.
3. We have similar data in two tabs.
4. I need a Macro that will create separate workbooks based on individual
Mfr in column "C".
5. But I need
Thanks David...its working
On Mon, Mar 11, 2013 at 6:34 PM, David Grugeon wrote:
> This works
>
> Application.OnTime Now() + TimeValue("00:00:05"), Sheets("Test").CodeName
> & ".CommandButton1_Click"
>
> Regards
> David Grugeon
>
>
>
> On 11 March 2013 21:52, Santosh V wrote:
>
>> Waiting for r
Hi Negi/Shrini,
The last one sent is working, thanks. But the button has to be on
'Consumed' sheet, instead of 'Main' sheet.
I think the code needs to be changed accordingly. I tried putting the
button in Consumed sheet but it did not work.
I hope you can fix this.
Thank you for bearing with m
This works
Application.OnTime Now() + TimeValue("00:00:05"), Sheets("Test").CodeName &
".CommandButton1_Click"
Regards
David Grugeon
On 11 March 2013 21:52, Santosh V wrote:
> Waiting for reply..
>
>
> On Mon, Mar 11, 2013 at 2:07 PM, Santosh V wrote:
>
>> Please find the sample file att
Paste in H2 and drag down.
=IF(AND(C2<41000,G2<=1),3500,IF(G2>1,0,((41365-C2)*3500)/365))
This is based on following assumptions:
- Bonus is calculated till 31.03.2013 @ Rs. 3500 for 365 days if bonus
wage is <= 1 and employee joined before 1.4.12 (which means he worked
for
Dear Prabhakar
Please clear Following things
1.What is full year (how much Bonus wage is full year)
2.In body of mail u r showing greater than 1 but in Sheet u r writing
less than 1
3.What is prorata basis
Regards
Shrinivas
On Mon, Mar 11, 2013 at 4:03 PM, Prabhakar S H wrote:
> Hi Tea
Waiting for reply..
On Mon, Mar 11, 2013 at 2:07 PM, Santosh V wrote:
> Please find the sample file attached.
>
>
> On Mon, Mar 11, 2013 at 1:41 PM, Abhishek Jain wrote:
>
>> A sample workbook would be helpful to understand better.
>>
>>
>> On Mon, Mar 11, 2013 at 12:32 PM, Santosh V wrote:
Hi Team,
in attached sheet i need to put If condition to get Bouns Amount of Rs
3500/- based on the below criteria:
= if Bonus Wage is >1 then Zero
= if he worked full year then need to pay 3500/-
= if he joined in between the year then need to pay on prorata basis
Pls help.
Rgds,
Pra
Dear Amar,
Now it automatically select the row.
Pl see the attachment.
IS it OK?
Warm Regards,
Gawli Anil.
On Mon, Mar 11, 2013 at 1:55 PM, amar takale wrote:
> Dear Anil
> Can you solved my issue?
>
>
> On Thu, Mar 7, 2013 at 4:33 PM, amar takale wrote:
>
>> Dear Anil,
>>
>>
>> Hi,You know
I would try
Application.OnTime Now() + TimeValue("00:00:05"), "Sheets(""Test"").
CommandButton1_Click"
First I think you need the . instead of the ! which you use in worksheet
functions. Next, you need a string in double quotes. Then where you want
the name of the file in the brackets you doubl
A sample workbook would be helpful to understand better.
On Mon, Mar 11, 2013 at 12:32 PM, Santosh V wrote:
> Any one ???
>
>
> On Mon, Mar 11, 2013 at 12:22 AM, Santosh V wrote:
>
>> Be,
>>
>> Its not what i am looking for. Thanks for your respone.
>>
>>
>>
>> On Mon, Mar 11, 2013 at 12:14 AM,
What I think you want to do is going to need some quite complex programming.
First, let me check that I have the right idea about what you want.
When any workbook opens on your computer, you want to have the the entire
row and the entire column of the active cell highlighted with a yellow
coloure
Any one ???
On Mon, Mar 11, 2013 at 12:22 AM, Santosh V wrote:
> Be,
>
> Its not what i am looking for. Thanks for your respone.
>
>
>
> On Mon, Mar 11, 2013 at 12:14 AM, Bé Trần Văn
> wrote:
>
>> Use CommandButton1_Click to select sheet
>> Code:
>>
>> Private Sub CommandButton1_Click()
>> Shee
27 matches
Mail list logo
