Hello
I have an excel file with multiple worksheets.
I need to hide many sheets in this file. However, only I should be able
to unhide the hidden sheet.
I did the following:
Visual Basic Editor
Double Click on the correct Project in the Explorer window
Click on the required Sheet name
Then
Hi Ashish,
Workbook protection.
http://spreadsheetpage.com/index.php/tip/spreadsheet_protection_faq1/
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: Wednesday, May 02, 2012 12:20 AM
To: Excel Macros
Subject: $$Excel-Macros$$
Hello,
Could you please help me on the attached file. Thanks in advance.
Regards,
Chandra Shekar B
On Tue, May 1, 2012 at 3:39 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*HI Chandru,*
* *
*File size will be very larege with 1000 controlls on worksheet.. I
suggest to use List
Hi
In G1 on sheet1 and copied across upto I1
=MATCH($A1|B2,Data!$A$2:$A$770|Data!$B$2:$B$770,0)
In B3 and copied down and across,
=INDEX(Data!$D$1:$BH$1,MATCH(LARGE(INDEX(Data!$D$2:$BH$771,G$1,),ROWS(B$3:B3)),INDEX(Data!$D$2:$BH$771,G$1,),0))
Both are array formulas.
Kris
--
FORUM
Did you attached Wrong file ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jorge Marques
Sent: 02 May 2012 15:36
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help on Changing code
Hi See the attached file
Function DatedDiff(dtStart As Date, dtEnd As Date) As String
Dim ArrStart
Dim ArrEnd
Dim ArrResult
ArrStart = Array(Year(dtStart), Month(dtStart), Day(dtStart))
ArrEnd = Array(Year(dtEnd), Month(dtEnd), Day(dtEnd))
You just hide your worksheet and protect your workbook..
ATL +T + P + W
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Pradhan
Sent: 02 May 2012 12:50
To: Excel Macros
Subject:
Hello Guru's
i am trying to do a progress chart comparing Actuals to budgeted and for
some strange reasons my chart is not over lapping as it should be.i have
overlapped a 100% however the chart still seem to be separated. am i
missing something? thanks
--
FORUM RULES (986+ members already
Congrats Raj. Proud of you
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 2 May 2012 21:30:32
To: excel-macrosexcel-macros@googlegroups.com
Reply-To:
यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
और अपनी तरक्की से छोटा कर दो आसमा के माप को.
हम दोस्तों की दुआए,छोड़े ना हरगिज़ साथ,
मेरे ओर से लाख-लाख बधाई, राजन बाबु आपको.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, May 2, 2012 at 9:30 PM,
Congrats Cheetah
Regards,
Sam
On Wed, May 2, 2012 at 10:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
और अपनी तरक्की से छोटा कर दो आसमा के माप को.
हम दोस्तों की दुआए,छोड़े ना हरगिज़ साथ,
मेरे ओर से लाख-लाख बधाई, राजन बाबु आपको.
--
Good work
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Wednesday, May 02, 2012 11:40 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
Congrats Cheetah
Regards,
Sam
On Wed,
Hello,
Hope you are doing fine!!
Please review the requirement and let me know if you have any consultants
for this opening .. If yes, Please forward resumes with contact details,
rate, location ASAP to harrysingh7...@gmail.com mal...@frontiertechllc.com
..
*POSITION:Java Developer*
hi all,
i m in need of help regarding finding the differences between four
columns i.e. RECEIPT No AMT. in sheet1 and RECEIPT No AMT in sheet2.i
would like to know the Formula which will highlight the differences between
the two columns in both sheets.
Receipt No Total Paid
Receipt No Total
Use this in F2 and Drag where Result is False mean that record does't exist
in first table
=SUMPRODUCT(--($A$1:$A$8=D2)*--($B$1:$B$8=E2))=1
See the attached File
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com
If you want to highlight the unmatched Record you can put this formula in
conditional formatting
Please see the attached file
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mr excel
Sent: 03 May
thanks for the speedy reply sir..how about using VBA for finding the
differences between the columns and pasting them(only the DIFFERENT
ones-Receipt no amount which are not matched to a new sheet one down the
other...
On Thu, May 3, 2012 at 12:08 AM, Mr excel excelkeec...@gmail.com wrote:
hi
A small correction for my requirement please i need to highlight those
receipt nos which had different amounts..Verma bhayya...formula ko change
karona please taaki,Receipt nos with different amounts highlight hue to
color kardena
thanks a lot for the help
On Thu, May 3, 2012 at
Hi,
I think it is already highlighting Receipt number with different amount.. I
mean which amount against same receipt number is not matching in first
table,
Do you want to highlight the receipt number in first table also??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From:
Congratulations Rajan, you're very generous with your time and expertise!
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Wednesday, May 02, 2012 9:01 AM
To: excel-macros
Subject: $$Excel-Macros$$ Rajan verma : Most Helpful Member-
Hi Asa,
I don't think there is any issues with constant, undefined variable types
or else, i do use option explicit for each module... I use late binding for
library references. The code that doesn't work is from msdn OpenAsTextStream
Method
Hi Asa,
I don't think there is any issues with constant, undefined variable types
or else, i do use option explicit for each module... I use late binding for
library references. The code that doesn't work is from msdn
OpenAsTextStream Method. I don't see any mistake I could have made. If yes
The msdn link here OpenAsTextStream
Methodhttp://msdn.microsoft.com/en-us/library/hwfw5c59(v=vs.85).aspx
I deleted my previous post just to make a few changes as English is not my
first language and I was even confused reading a last time after posting.
--
FORUM RULES (986+ members already
Oops my mistake, Set f = fs.GetFile(y:\test2.txt)
I didn't specify the path, nothing related to flash memory and else...just
that msdn used filename to declare the path+file variable and I got
confused,to me filename means filename not file path...since the getfile
method is linked to thefs
Congratulations Rajan, a great contribution to the forum
Thanks also for your patience and help
A hug!
Chilexcel from Chile
2012/5/2 Asa Rossoff a...@lovetour.info
Congratulations Rajan, you're very generous with your time and expertise!
Asa
** **
*From:*
Hi Pascal,
I'm glad you found the problem (specifying the whole path with Getfile)
With late binding you don't need to set a library reference.
If you don't set a library reference, the constants aren't defined.
You can easily verify the values of the constants in the immediate window
like
Getting error bhayy..please correct.
On Thu, May 3, 2012 at 12:59 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
** **
*Wanna Use VBA??
*
See the attached Sheet.. You can A*dd record dynamically* in second table
Try this ;
Sub GetUnMatchedValueonNewSheet()
Sorry Verma,,i had messed up everything here.Got confused with the
requirement.
What i want actually is to find out the differences between the FIRST table
with Receipt No Amt and SECOND table with Receipt No Amt.
Example: The receipt no 1151881 in Master data is 4500
It should match the
Congrats Rajan ..
On Wed, May 2, 2012 at 2:21 PM, ChilExcel chilexcel...@gmail.com wrote:
Congratulations Rajan, a great contribution to the forum
Thanks also for your patience and help
A hug!
Chilexcel from Chile
2012/5/2 Asa Rossoff a...@lovetour.info
Congratulations Rajan,
Congratulation Rajan
On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
April'2012
He has posted 185 posts in April 2012 and helped many people through his
expertise. He has been
If you want to calculate for a different net amount (m) just put the new
value in the cell at the top marked Target. All the calcs will then
change. You can also change (h) if required but if you change any of the
other formulas the whole exercise has to be reworked.
On 3 May 2012 13:49, Milin
Dear all
I am having a sheet ,which contains data of various parties.
I want to insert row at each change in party name automatically ,whether it
can be done automatically or i have to make it manually
Regards
Vaibhav
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
*Congrats Brother.*
On Wed, May 2, 2012 at 8:15 PM, xlstime xlst...@gmail.com wrote:
Congratulation Rajan
On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
April'2012
Hi i wanted to insert a row between cell A1 A2 at each change in column A
text
On Thu, May 3, 2012 at 10:39 AM, Maries talk2mar...@gmail.com wrote:
*Can you share sample file...*
On Wed, May 2, 2012 at 9:58 PM, vaibhav joshi vaibhav...@gmail.comwrote:
Dear all
I am having a sheet
34 matches
Mail list logo