Dear Ram,
You can try below macro with Rajan's Suggestion to reduce your file size..
Option Explicit
Sub SHRINK_EXCEL_FILE_SIZE()
Dim WSheet As Worksheet
Dim CSheet As String 'New Worksheet
Dim OSheet As String 'Old WorkSheet
Dim Col As Long
Dim ECol As Long 'Last Column
10 tips for working more efficiently in Excel
#1: Exploit defined names
Defined names aren’t just for ranges. You can use a defined name to define
a constant value, such as a discount amount. Use the feature as you
normally would, entering the literal value or expression that evaluates to
the
Dear Vivek,
Without using VBA
Please try through below function..
=get.cell(63,Indirect(RC[-1],))
See attached sheet for more clarity.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
Hello All Expert,Can anyone give me any template or suggestion
On Fri, Apr 20, 2012 at 10:41 AM, sushil kumar sushilck.sha...@gmail.comwrote:
I want to multiple user can use do the entry in excel sheet and that data
save into central access database
Please help any one this is very urgent
Hi All,
I have one JPG/Png/Gif format file, is there any way where i can convert
this JPG format file to Excel file to make some changes?
your reply will be greatly appriciated.
--
Shekhar Sharma
9910010060
Life consists not in holding good cards but in playing
those you hold well
Before
See: http://www.xcelfiles.com/VBA_InsertImgs.html
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or
Try Using Workbook Sharing.. in Maped Network Drive...
On Fri, Apr 20, 2012 at 12:54 PM, sushil kumar sushilck.sha...@gmail.comwrote:
Hello All Expert,Can anyone give me any template or suggestion
On Fri, Apr 20, 2012 at 10:41 AM, sushil kumar
sushilck.sha...@gmail.comwrote:
I want to
Dear Team
Thanks for the reverts.
Please find attached the file having my requirement.
Regards
Rajender Soni
On Thursday, April 19, 2012 4:26:09 PM UTC+5:30, Soni.Rajender wrote:
Dear Team
Please find attached the excel workbook having a pivot table in one sheet
and the relevant
Rajan pls what did you do differently to get the portion you only need
On Thu, Apr 19, 2012 at 5:05 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi
Please see the revised version
** **
Rajan.
** **
*From:* excel-macros@googlegroups.com [mailto:
Hi,
Can you provide the dummy data, as provided data is not the complete one,
it seems you have provided pivot table data.
Regards
Shekhar Sharma
On Fri, Apr 20, 2012 at 3:28 PM, Soni.Rajender soni.rajen...@gmail.comwrote:
Dear Team
Thanks for the reverts.
Please find attached the file
Hey Kris,
Thanks for the quick response, however I am looking for the code for not
just adding the image in excel.
I want to use the the data available in that picture to further make the
changes in excel.
Example:
I had the data set available in excel like, result out of 100:
Student Name
Dear Members,
Here I have attached Excel file in which the data is live streaming from
other software.
What I need is to set popup alert for specific value of securities price.
This is a live streaming work sheet, the Colum C shows the company name
and Colum E show the current price of
Try this,
Private Sub updatemonth()
Sheets(Brand).Range(C1).Select
If ActiveCell.Value = Then
Do Until ActiveCell.Value = Total
ActiveCell.Value = Month i want
ActiveCell.Offset(1, 0).Select
Loop
Else
MsgBox No job to run
End If
End Sub
Regards
Shekhar Sharma
On Wed, Aug 31, 2011 at 11:14
Hi Ketan,
For reference check purpose please use the formula from Cell D9 to D17 as :
=RANDBETWEEN(1.4,5)
and then by using Alt+F11 and then in your sheet 1 update the code as:
Dim Nifty, Titan As String
Private Sub Worksheet_Calculate()
Nifty = Range(D10).Value
Titan = Range(D17).Value
If
Hi Expert,
Please see attached sheet.
Divaker
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be
Dear Divaker,
Please try it..
Function Initial_Count(rng As Range)
i = 0
For Each cell In rng
If IsError(cell) = False Then
Exit For
End If
i = i + 1
Next
Initial_Count = i
End Function
See attached sheet..
Thanks regards,
Noorain Ansari
On Fri, Apr 20, 2012 at 5:06 PM, Divaker Pandey
thank for reply noorain, but is it possible with any excel function
i want to avoid macro
it will be very gr8 help if you response early.
Thanks .
On Fri, Apr 20, 2012 at 5:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Divaker,
Please try it..
Function Initial_Count(rng As
sir, i want a income tax calculating software using excel bywhich i
can calculate tax and take return querterly and annualy and the form
16 will be automatically generated and i can take print out of
that.please help.
--
With Regards ..
Tarun Mondal
--
FORUM RULES (986+
For that you have to google the available softwares and their functionality.
Regards
Shekhar Sharma
On Fri, Apr 20, 2012 at 6:23 PM, Tarun Mondal tarunmondal1...@gmail.comwrote:
sir, i want a income tax calculating software using excel bywhich i
can calculate tax and take return querterly and
Group is not allowing large size Files. So I am sending the Excel file and
Access DB on your personal mail. J
Rajan
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: Apr/Fri/2012 06:55
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Need help
Hi,
In shared
=SUMPRODUCT(--ISNA(A1:Z1))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Divaker Pandey
Sent: Friday, April 20, 2012 7:28 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count intial #NA in a row using excel function
thank for
I think No, you can't change.
You can convert it in PDF and make it readable by One Adobe Tools [name I
don't remember) , Please google it.
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shekhar Sharma
Sent: Apr/Fri/2012 02:32
To:
Hello all group
I share my new videos uploaded to my youtube page
Please see this link
Chilexcel PunteroCelda.xla
http://www.youtube.com/watch?v=lZOsLCBSR2wcontext=C487180dADvjVQa1PpcFNtKYvBzpQ5HbSYGT3M8FSjxtRwaVrbdaM
=
All videos
http://www.youtube.com/user/timextag41
Chilexcel
--
FORUM
It's working with this Code on Worksheet_Change event and I Format your Year
Series as Text.
Sub SetSourceRange()
Dim rngCell As Range
Dim rngSource As Range
For Each rngCell In Range(rngRange)
If rngCell.Value 0 Then
If rngSource Is Nothing
Try with CSE
=SUM(IF(NOT(ISERROR(A1:L1)),A1:L1))
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Fri/2012 05:59
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Count intial #NA in a row using excel
Thank for reply
but sorry Don Guillett and Rajan, the given solution does not work.
Please do it.
Divaker
On Fri, Apr 20, 2012 at 7:16 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Try with CSE
** **
=SUM(IF(NOT(ISERROR(A1:L1)),A1:L1))
** **
Rajan.
** **
*From:*
HI Divakar,
Please check the attached file,
I have put My and Don's formulas with results J
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Divaker Pandey
Sent: Apr/Fri/2012 07:32
To: excel-macros@googlegroups.com
Subject: Re:
Amazing J it would be great if you can share the code behind it.
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: Apr/Fri/2012 07:10
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ New Videos excel by Chilexcel
your post was of great importance. Thanks Friend
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not
Rajan
In the video is a download link
Download here please
http://sites.google.com/site/chilexcel/descargas-gratis
Regards
Chilexcel
2012/4/20 Rajan_Verma rajanverma1...@gmail.com
Amazing J it would be great if you can share the code behind it.
** **
Rajan.
** **
*From:*
Please
download ; http://www.minipdf.com/
I tried it and it works fine ...
Chilexcel
2012/4/20 Rajan_Verma rajanverma1...@gmail.com
I think No, you can’t change.
** **
You can convert it in PDF and make it readable by One Adobe Tools [name I
don’t remember) , Please google
Please see
http://www.minipdf.com/
I tried it and it works fine ...jpg at xls
Chilexcel
2012/4/20 Shekhar Sharma shekhar1...@gmail.com
Hey Kris,
Thanks for the quick response, however I am looking for the code for not
just adding the image in excel.
I want to use the the data available in
Hi Bro,
Can u develop it in English..
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ChilExcel
Sent: Apr/Fri/2012 08:23
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ New Videos excel by Chilexcel
Rajan
In the video
Yes...!!! ok
2012/4/20 Rajan_Verma rajanverma1...@gmail.com
Hi Bro,
Can u develop it in English..
** **
Rajan.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *ChilExcel
*Sent:* Apr/Fri/2012 08:23
*To:*
Dear Experts,
I'm preparing a macro to checks some reports, I have a folder that contains
some text files with user ids other details with different files names
an excel sheet contains the user ids. Now i wanna know if any of user ids
mentioned in excel sheet are matching with user ids
Hello Divaker,
Consider data is in A1:Z1.
If you are looking to find first #N/A in the range count #N/A after that
occur consecutively, here is a one way:
Only work with XL2007 or later:
Hi
Can you send your text file
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prabhat.shrivasta...@gmail.com
Sent: Apr/Fri/2012 09:46
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Macro to search text based on an array
Dear
Hi rajan,
Thks fot yr revert, there arnd morethan 10 text files with diffrent headers but
all files having the user ids as mentioned on excel sheet.
Awaitaing yr response in this..
Regards,
Prabhat S
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
Is your text file Name is UserID or that file contain UserID?
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prabhat.shrivasta...@gmail.com
Sent: Apr/Sat/2012 07:56
To: excel-macros@googlegroups.com
Subject: RE:
39 matches
Mail list logo