Hi boss
The challlenge is that users can work in the template cos all the cells are
locked could u kindly have only the formulas locked so the non formula
cells can be edited tried lockin all formulas only from the main template
but that didnt wk thanks
-- Forwarded message
its free of cost and take half an hour to complete
go to http://dsaksharta.in/
register and go..
Warm Regards,
Gawli Anil
On Fri, Feb 1, 2013 at 1:24 PM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Please provide more details of the certification;
** **
**1) **From where
Okay thanks.
Best Regards,
Amit Desai
+91 98672 32534
From: अनिल नारायण गवली [mailto:gawlianil8...@gmail.com]
Sent: 01 February 2013 14:03
To: excel-macros@googlegroups.com; Amit Desai (MERU)
Subject: Re: $$Excel-Macros$$ Successfully passed the microsoft digital
certification course.
its free
Good Work
and thanks a lot anil for sharing this gr8 info but plz be sure to share
any such future opportunity
Thanks once again
On Fri, Feb 1, 2013 at 2:03 PM, अनिल नारायण गवली gawlianil8...@gmail.comwrote:
its free of cost and take half an hour to complete
go to http://dsaksharta.in/
Hi
Please remove my id from the group ..
Regards
Kailash
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Excel Beginner
Sent: Friday, January 18, 2013 12:00 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need formula
Sir,
I have data of Station and category in columns a and b. But I want the
report
in category wise as in columns h to k. When i use the sumproduct formula it
works
and it is not working in vba. Please guide how to modify the vba to get the
desired
result.(formula used is available in the
Hello Experts
i have some general data in sheet one, i want to enter a start date and an
end date in sheet two so that items within these dates should pop up, my
formulas are not working , kindly assist. thanks
--
Join official Facebook page of this forum @
Thanks Experts, i have aadjusted my formula, its working now. thanks
On Fri, Feb 1, 2013 at 11:36 AM, Hilary Lomotey resp...@gmail.com wrote:
[image: Boxbe] https://www.boxbe.com/overview This message is eligible
for Automatic Cleanup! (resp...@gmail.com) Add cleanup
Dear Kailash,
Send your request on below email ID.
macros+unsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com
.
On Fri, Feb 1, 2013 at 3:45 PM, Mishra, Kailash (GE Capital, Non-GE)
kailash.mis...@ge.com wrote:
Hi
** **
Please remove my id from the group ……
Dear Anil,
Thank you for your file and effort. Every time I run the file, it gives me
the following error: Compile Error: Invalid outside procedure.
Do you have advice on how I may fix this so I may test?
Thank you again.
Alpesh
On Thursday, January 31, 2013 11:33:36 PM UTC-5, अनिल नारायण
Dear Anil,
Please accept my apologies. I had made an error on my part in accidentally
having deleted a letter from the file you provided. As a matter of fact,
your solution works great. Thank you very much for all of your efforts on
this. I sincerely appreciate it.
Best regards and wishing
I've used this since Office97/2003
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, _
filename:=enter_path_and_file_name_here, _
Quality:=xlQualityStandard, _
IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False
Dear Ayush,
I have to click on this link every time to access group, I'm still confused
that i haven't become member of this group
On Saturday, July 23, 2011 5:50:06 PM UTC+5:30, Ayush Jain wrote:
Hello everyone,
Please adhere to below rules of the forum. You will be banned without
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Fri, February 1, 2013 10:24:44 AM
Subject: Re: $$Excel-Macros$$ convert Excel into pdf
I've used this since Office97/2003.
(It is currently functioning in Excel2010)
Dear Anil,
Thank you again for your efforts. It seems however that as I run the
program, that in cases where there is less that 5 within a category, the
transpose then erroneously pastes the figures. For example, if I were to
move the last data set of 1,2,5 to the first and move all else
Any solution friends.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: joseph camill joseph.cam...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 1 Feb 2013 09:56:08
To: excel-macros@googlegroups.comexcel-macros@googlegroups.com
Reply-To:
I am wondering if someone can suggest a smart solution to identify the
pattern of email id.
Name ID pattern Ravi verma ravi.ve...@gmail.com fff@gmail.com Ravi
verma rve...@gmail.com f...@gmail.com Ravi verma r.ve...@gmail..com
f@gmail.com Ravi verma rav...@gmail.com ff...@gmail.com
Use
Fn first name
Fni or fi first intial
Ln last name
Lni or li last name intial
Sent on my BlackBerry® from Vodafone
-Original Message-
From: rajan verma rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Fri, 1 Feb 2013 09:59:08
To: excel-macros@googlegroups.com
Hi Friends,
Need a macros to split each spreadsheet into a different workbook and save
as the tab name.
For Example : Split Apple tab only from current workbook and save it as
new workbook , file name should be tab name .
Please find atatchment.
Regards,
Santhosh
--
Join official Facebook
Hi Sandhosh.
Sub Splitsht()
ChDir C:\Documents and Settings\user\Desktop\folder
Dim wrksht As Worksheet
For Each wrksht In ThisWorkbook.Worksheets
wrksht.Select
wrksht.Copy
ActiveWorkbook.SaveAs Filename:=wrksht.Name .xlsx
ActiveWindow.Close
Next
End Sub
Thanks
Have you done any VBA on your own?
This is simply a matter of recording a macro in which you perform the steps for
one sheet.
Then, wrap a loop around the code, substituting a variable for the sheet and
file names.
it can be done fairly quickly...
let us know what part you need help with.
Thanks a lot ... Vijay
On Fri, Feb 1, 2013 at 11:30 PM, vijayajith VA vijayajith...@gmail.comwrote:
Hi Sandhosh.
Sub Splitsht()
ChDir C:\Documents and Settings\user\Desktop\folder
Dim wrksht As Worksheet
For Each wrksht In ThisWorkbook.Worksheets
wrksht.Select
Hi Santhosh,
Please find attached workbook and let me know if it works.
Thanks and regards,
Shekhar
On Friday, 1 February 2013 23:14:56 UTC+5:30, mks...@gmail.com wrote:
Hi Friends,
Need a macros to split each spreadsheet into a different workbook and save
as the tab name.
For
ashish , can you explain
On Fri, Feb 1, 2013 at 10:27 AM, koul.ash...@gmail.com wrote:
**
Use
Fn first name
Fni or fi first intial
Ln last name
Lni or li last name intial
Sent on my BlackBerry® from Vodafone
--
*From: * rajan verma rajanverma1...@gmail.com
Thanks Ashish. Works like charm,
As always you all are a great help.
On Thursday, January 31, 2013 8:56:30 PM UTC+4, ashish wrote:
*Try this code*
Sub SJ()
Application.DisplayAlerts = False
Dim i As Long, j As Long
On Error Resume Next
Sheets(Output).Delete
Hi All,
I've macro like:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range(B23:HH400)) Is Nothing Then
ActiveWorkbook.Names(ActiveRow).RefersTo = = ActiveCell.Row
End If
End Sub
unfortunately I can't undo any changes. Is the anyway I can
Bravo again ♍Ɣ friend well done and thanks for your massive and valuable
support.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sat, 2 Feb 2013 11:49:07
To:
Excellent work again Prince. Keep up the great work.
On Sat, Feb 2, 2013 at 12:29 PM, resp...@gmail.com wrote:
**
Bravo again ♍Ɣ friend well done and thanks for your massive and valuable
support.
Sent from my BlackBerry® smartphone from Airtel Ghana
--
*From: *
Congratulation!!
Keep up the gud work.
On Fri, Feb 1, 2013 at 11:31 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Excellent work again Prince. Keep up the great work.
On Sat, Feb 2, 2013 at 12:29 PM, resp...@gmail.com wrote:
**
Bravo again ♍Ɣ friend well done and thanks for your
Sub test()
Application.DisplayAlerts = False
Dim i As Long, s As Long
Sheets(1).Select
For i = 3 To Range(c65356).End(xlUp).Row
s = Application.WorksheetFunction.CountIf(Range(c:c), Range(c i))
- 1
Call merge_rng(Range(c i :c i + s))
i = i + s
Next
For i = 3 To
30 matches
Mail list logo