I want to convert workbook as PDF not worksheet. Is it possible?
On Wednesday, 13 November 2013 13:22:31 UTC+5:30, Ravi Kumar wrote:
K download primopdf or nitropdf software or any pdf machine software
Then u can convert excel into pdf
By using “activesheet.printout” or by pressing
Sure
On Wed, Nov 13, 2013 at 11:06 AM, Bill Q ronsmith...@gmail.com wrote:
On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin wrote:
My Pleasure.. You have given me new title.
On Fri, Dec 14, 2012 at 12:57 AM, Bill Q ronsm...@gmail.com wrote:
Just what the doctor
yah thanks All
On Wed, Nov 13, 2013 at 1:56 PM, Vinay Saraf vinaysa...@lodhaco.com wrote:
Yes you can download nitro professional from torrentz.com
This can convert worksheet as well as workbook in pdf
On 13 Nov 2013 13:36, Pavan Valluru pavansai.vall...@gmail.com wrote:
I want to convert
Hi Jocky, try this option in VBA.
Sub ImportTXT()
Dim DateTime As String '7 to 29
Dim CardHolder As String ' 33 to 49
Dim DoorZone As String ' 55 to 83
Dim Status As String ' 93 to 103
Dim nFile, rowTxt As String
nFile = C:\temp\1234.txt 'change according to the way of your TXT
Try this:
Sub seldate()
Range(F10).Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = 1/1/2011
Range(F11).Select
ActiveCell.FormulaR1C1 = =R[-1]C+1
Range(F11).Select
Selection.Copy
Range(F12:F41).Select
ActiveSheet.Paste
Range(G12).Select
Selection.Copy
Range(H12).Select
Dear experts,
I am unable to write the formula for the attached excel file.
Please help me to create formula please..i have tried many a times, but
unable to write. I have elaborate my query in the file itself. Please
please find the attachment.
Thanks a ton in advance.
With warm
Sorry- attachment missed
Dear experts,
I am unable to write the formula for the attached excel file.
Please help me to create formula please..i have tried many a times, but
unable to write. I have elaborate my query in the file itself. Please
please find the attachment.
Thanks a ton
PFA with range changed from 23rd to 100th lines. It is working fine.
Alternatively you can use named range to make it more easy (Solution
Attached )
As far as benefits / limitations are concerned array solutions are very
powerful compared to non array. But I personally prefer array solutions
Ok I even managed to modify this so that the source can go upto 1000
lines of match info (or more should I require it). This is a very
powerful template that I can see multiple applications for. Thank You Very
Much Kantila. MUCH appreciated !
On Wednesday, November 13, 2013 11:22:40
I don't see anything else except your comment sure. Am I missing
something ?
On Wednesday, November 13, 2013 3:21:51 AM UTC-5, Enrique Martin wrote:
Sure
On Wed, Nov 13, 2013 at 11:06 AM, Bill Q ronsm...@gmail.com javascript:
wrote:
On Thursday, December 13, 2012 8:48:25 PM
Dear all experts,
Is my query is valid ? can we lookup the closest data as like the
attachment earlier. Please help on the attachment. Thanks to all.
With warm regards,
Rajan Sharma
On Thu, Nov 14, 2013 at 9:49 AM, Rajan sharma rajansharma9...@gmail.comwrote:
Sorry- attachment
Dear Ranjan,
Are You want delete all the rows which contain orange data in column E. in
sheet one.
Thanks,
Ashish
On Thursday, 14 November 2013, Rajan sharma wrote:
Dear all experts,
Is my query is valid ? can we lookup the closest data as like the
attachment earlier. Please help
Dear rajan,
Pl elaborate more on this query
Warm Regards,
Gawli Anil
Thanks Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Nov 14, 2013 at 11:57 AM, Rajan sharma
rajansharma9...@gmail.com wrote:
Dear all experts,
Is my query is valid ?
Dear Sirs,
I want to find the Closest match from A and D column. i mean if the
word contains in A column similar to D column (it may be 1st , 2nd or any
middle line or last line) then the closest matches should be lookup. I
hope i could able to explain you all experts,
Thanks to all
14 matches
Mail list logo