Good Morning Don,
Thanks a lot this stuff worked for me, but minute update is required in
this macro can we get the source tab name inserted in a column in the
summary sheet.
Regards,
Lucky S
On Mon, Oct 29, 2012 at 7:52 PM, Don Guillett dguille...@gmail.com wrote:
Should do it in .xlsM
Hi Experts,
Please solve this Query.
Regards,
Priyanka
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Dear Priyanka,
See attached file.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish
vaishpriyanka2...@gmail.com wrote:
Hi Experts,
Please solve this Query.
Regards,
Priyanka
--
Join official
Hi Kuldeep,
Thank a lot.
Regards,
Priyanka
On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Dear Priyanka,
See attached file.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
On Tue, Oct 30, 2012 at 11:47 AM,
Dear All,
Thanks
but i want solution through formula.
On Tue, Oct 30, 2012 at 1:16 PM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
Dear Priyanka,
You can use Remove duplicates in Excel 2010 and 2007. Select your data and
Alt+A+M.
You will found only unique data.
Regards,
=IF(EXACT(COUNTIF($A$1:A1,A1),1),A1,)
copy at b1 and drag it
On 30 October 2012 13:21, Priyanka Vaish vaishpriyanka2...@gmail.comwrote:
Dear All,
Thanks
but i want solution through formula.
On Tue, Oct 30, 2012 at 1:16 PM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
Dear Gurus,
Please help me on the attached excel query.
If greater than EOT then the cell color should be red elase green
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
Hi,
find as per ur requirement ..solution conditional formatting.
On Tue, Oct 30, 2012 at 3:55 PM, Sundarvelan N nsund...@gmail.com wrote:
Dear Gurus,
Please help me on the attached excel query.
If greater than EOT then the cell color should be red elase green
Thanks
N.Sundarvelan
Hi Sundarvelan,
PFA.done with conditional formatting.
Regards,
Prasad K
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: Tuesday, October 30, 2012 3:55 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If greater then
hi,
try this
Regds
On Tue, Oct 30, 2012 at 4:36 PM, Prasad Kambli (MUM/Abacus Analytics)
prasad.kam...@imrbint.com wrote:
Hi Sundarvelan,
PFA…done with conditional formatting.
** **
Regards,
Prasad K
*From:* excel-macros@googlegroups.com [mailto:
Dear Gurus,
Please help me to Count the no of Red colored cells and green colored cells.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate
Dear Gurus,
Thanks for all your replies it worked. Thanks lot.
Thanks
N.Sundarvelan
9600160150
On Tue, Oct 30, 2012 at 4:41 PM, Rohan Young rohan.j...@gmail.com wrote:
hi,
try this
Regds
On Tue, Oct 30, 2012 at 4:36 PM, Prasad Kambli (MUM/Abacus Analytics)
prasad.kam...@imrbint.com
Please see the attached file
On Tue, Oct 30, 2012 at 4:16 PM, Sundarvelan N nsund...@gmail.com wrote:
Dear Gurus,
Thanks for all your replies it worked. Thanks lot.
Thanks
N.Sundarvelan
9600160150
On Tue, Oct 30, 2012 at 4:41 PM, Rohan Young rohan.j...@gmail.com wrote:
hi,
try
Please see the attahed file
On Tue, Oct 30, 2012 at 4:16 PM, Sundarvelan N nsund...@gmail.com wrote:
Dear Gurus,
Thanks for all your replies it worked. Thanks lot.
Thanks
N.Sundarvelan
9600160150
On Tue, Oct 30, 2012 at 4:41 PM, Rohan Young rohan.j...@gmail.com wrote:
hi,
try this
Dear Rajan and ANil
Sample file is already attached .
Dear Vijay
Can u explain me the file u send
Regards
Shrinivas
On Mon, Oct 29, 2012 at 7:27 PM, Vijay Kr. Aggarwal
vjaggarwal2...@gmail.com wrote:
Hi Shrinivas,
Please check attached file. I hope this will answer your query.
regards,
hi Sundarvelan,
You can use the following array formulas for count the Red Green cells.
Please note it's calculating the cell values not cell colors. See the
attached file.
=COUNT(IF(D2:AG2C2,D2:AG2))
=COUNT(IF(D2:AG2=C2,D2:AG2))
Aamir Shahzad
On Tue, Oct 30, 2012 at 4:11 PM, Sundarvelan N
Hi Shrini,
First sheet:- Raw Data
Second Sheet :- Criteria is given in this sheet.
third sheet :- Final output would be pasted here by using criteria
from second sheet.
regards,
Vijay
On 10/30/12, Shrinivas Shevde shrinivas...@gmail.com wrote:
Dear Rajan and ANil
Sample file is already
OK
Option Explicit
Sub getallSAS()
Dim i As Long
Dim dlr As Long
Dim cr As Double
Dim slr As Long
Sheets(all up).Select
Application.ScreenUpdating = False
ActiveSheet.UsedRange.Offset(1).Clear
Columns.ColumnWidth = 2
Rows.RowHeight = 4
On Error Resume Next
For i = 2 To Sheets.Count
With Sheets(i)
agree!!!
On Monday, October 29, 2012 11:36:55 PM UTC-5, David Grugeon wrote:
I am not going to spend my time downloading your file untill I know what
it is you want. Please do us the courtesy of copying the steps from the
file and putting them in your post.
Also put a more relevant
*Thanks Rajan.*
*
*
*I can be able to work now in the protected sheet with macro/conditional
formatting, but whenever I would like to edit / enter the data in this
sheet, I use to unprotect the sheet, and if I enter again or move to any
other field the sheet is automatically getting protected.*
*
So you want button for protect or Unprotect Sheet?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: Pravin Gunjal [mailto:isk1...@gmail.com]
Sent: 30 October 2012 6:52
To: excel-macros@googlegroups.com; Rajan Verma - Gurgaon Excel
Subject: Fwd: $$Excel-Macros$$ Re: VBA enabled
Hi Team,
I have a report deliverable every hour of the day. Multiple users are
working on it.
Delivery Start from 8:00 AM to 10 PM.
Is there any way I can set alert message (for all the users) wihtout using
outlook, windows scheduler.
It will be helpful for me to deliver the reports on every
Execute it at 8 o clock
Sub ShowPopUp()
Msgbox Send Massange
Application.OnTime Now+Timevalue(01:00:00),ShowPopUp
End Sub
Sub StopPopUp()
On Error Resume next
Application.OnTime Now+Timevalue(01:00:00),ShowPopUp,,False
End sub
Regards
Rajan verma
+91 7838100659
Hello Friends,
i want a vba code to compare whether the new password i entered corresponds
with the confirmation password ie
old password
new password
confirm new password
i tired the following code but didnt work
if textbox3.value = textbox2.value then
unload me
else
msgbox check the
Hi Expert,
Kindly provide any solution for following problem Preserving number leading
0 querytable excel
.
divaker
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread
Hi Sir,
Try this one.
Regards,
Kuldeep Singh
On Tue, Oct 30, 2012 at 9:48 PM, Divaker Pandey divake...@gmail.com wrote:
Hi Expert,
Kindly provide any solution for following problem Preserving number
leading 0 querytable excel
.
divaker
--
Join official facebook page of this forum @
Hi Sir,
Please see this link. I hope it will help you.
http://blog.sqlauthority.com/2012/09/30/sql-server-preserve-leading-zero-while-coping-to-excel-from-ssms/
Regards,
Kuldeep Singh
On Tue, Oct 30, 2012 at 10:04 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Sir,
Try this one.
What line is producing an error?
I ran it and it worked fine.
But my sheets weren't password protected.
At no point in your macro are you applying the password to unprotect your
sheets or workbook.
Since I don't know what kind of Protection you've issued on your workbook and
sheets,
it's
Since being able to interrupt the macro isn't the highest priority,
I'd like to concentrate on the foreground processing issue.
If it runs in Foreground, I shouldn't HAVE to interrupt it!
The problem is: A macro that takes 5 minutes running in the foreground takes
30 minutes in the background.
OK, I think I see the problem.
I think I need to define some terms for you.
The term collection is very descriptive.
It is used to define a group of objects.
The images on a sheet are part of a collection of images.
A workbook contains a collection of WorkSheets.
The actual term Sheets refers to
file with formula
On 30 October 2012 16:41, Sundarvelan N nsund...@gmail.com wrote:
Dear Gurus,
Please help me to Count the no of Red colored cells and green colored
cells.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
Hi,
I have a new project at work. to create a spreadsheet that shows
percentage increases and decreases based on categories. Would like to do a
trendline showing the history of this.
does anyone have a spreadsheet with data and that type of chart along with
the calculations you could send me
Pls can anybody guide me
On Tue, Oct 23, 2012 at 3:51 PM, amar takale amartak...@gmail.com wrote:
Hi Experts,
Pls Solved Problem in Attached Excel
Regards
Amar
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
33 matches
Mail list logo