In search of a solution using a macro
I would like to copy the 'active sheet' and rename each sheet created from
a list on
a hidden sheet in the file. The list changes based on which 'class' is
selected from the
list on the active sheet.
I have a sheet1 "student" = activesheet
s
In search of a solution using a macro
I would like to copy the 'active sheet' and rename each sheet created from
a list on
a hidden sheet in the file. The list changes based on which 'class' is
selected from the
list on the active sheet.
I have a sheet1 "student" = activesheet
s
*Here is the new requirement. Kindly go through the Profile, If profile
suits any of your consultants .. please share us details...*
*Title: Solution Architect*
*Location: Miami, FL*
*Duration: 6 Months*
*Description:*
*Must be able to demonstrate all of the needs below*
*Drive solution
*Here is the new requirement. Kindly go through the Profile, If profile
suits any of your consultants .. please share us details...*
*Title: Solution Architect*
*Location: Miami, FL*
*Duration: 6 Months*
*Description: *
*Must be able to demonstrate all of the needs below *
*Drive solutio
Hello,
On Thursday, January 23, 2014 at 9:53:22 AM UTC-5, sale sales wrote:
>
> Hello Professionals,
>
> We’ve an excellent *Pega Senior System Architect* consultant available
> immediately for new contract (C2C) position. Please send your requirements
> at m...@itconsultservices.com call me
I want to be able to point-and-click to individual cells within a specified
worksheet range and inset a now() timestamp:
Option Explicit
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count <> 1 Then Exit Sub
Application.EnableEvents = False
If Target = "
Thank you Noorain.
Yes, Evaluate() does put a value in the cell instead of a formuala. That is
great.
Do you have any idea how to make the equation include "<=" in the last
clause?
On Friday, June 1, 2012 8:58:42 PM UTC-4, NOORAIN ANSARI wrote:
> Dear Mark,
>
> You can
This formula works in a cell:
=SUMIFS(O$2:O$26196,A$2:A$26196,A2,N$2:N$26196,"<="&N2)
1) I want to have vba make this calculation - because calculating it in
each cell bogs down the xls.
I got the following vba to work but I cant figure out how to add "<=" to
the last clause (col N has dates):
.R
Justyna,
Did you ever figure this out? I am currently going through the same
issue. Oddly, everyone I send the file to has the ability to see the
data populate as it should. However, I (the author of the file) is
receiving the same REF# error.
Let me know,
Thanks,
On Sep 21, 3:15 am, e_milia
> In the formatting expression, "H" means to display the Hour without
> leading "0"'s.
> since this isn't a TIME, I suspect you were trying to use this format
> statement
> as if it were similar to C++. It's not.
> How it
Can not use like that.
All I know is which column i need to use. I do not know how long is the sum
range and where to start.
That's why I have FBTFirstrow and FBTlastrow . I need to have sum formular
in the cell so i can verify the formula
On Thu, Jun 24, 2010 at 3:22 PM, saggi wrote:
> If you
f the formula is
> ='[Book1.xls]Sheet 2'!$A$3. Unticking edit directly in cell will mean
> you can't edit formula's in the cell, you have to do it in the formula
> bar.
>
> Cheers,
>
> Spud
>
> On Mar 22, 10:34 pm, Mark Kim wrote:
> > The pr
rkbook and go to the reference cell
if the value is a cell, go to the cell
well, I think this logic will work.. I just don't know how to write this..
Anyone please? ^ ^
On Mon, Mar 22, 2010 at 5:57 PM, Yahya wrote:
> Dear Mark
>
> I think you can do it by just using a Hyperlink. No
On Fri, Feb 26, 2010 at 4:44 PM, Ayush wrote:
> Hi Markkim,
>
> Would you please send the sample file containing this data?
>
> Best regards,
> Ayush Jain
>
> On Feb 26, 6:18 am, Markkim wrote:
> > Hi
> > I have been trying to make these but have failed. ^ ^;;
> > I’d like to create a macro
> >
Hi, Thanks for the code.
But I tried but it doesn’t seem to work as expected. Can I ask you this
please?
in the data sheet you uploaded, what I want is to select Dat1 to Data 7 and
remove blank rows. In my real data I work with, there are 6 rows between the
last transaction record and FBT detail
Sorry I didn't attach an file.
hm.. not sure how to attach a file.
Hope this is ok..
On Sun, Jan 17, 2010 at 7:50 AM, Mark Kim wrote:
> Hi Praveen
>
> Thanks Million!!! This is exactly what I was looking for..
>
> Thanks a lot !!!
>
>
> On Sun, Jan 17, 2010
Hi Praveen
Thanks Million!!! This is exactly what I was looking for..
Thanks a lot !!!
On Sun, Jan 17, 2010 at 1:35 AM, kvc praveen kumar wrote:
> Hi,
>
> Please find the attached file and let me know if this is what you are
> looking for. I used worksheet events to impement the same.
> Regards
I have what I believe to be a very simple solver problem, but keep
getting the wrong answers, I can easily answer the problem myself, but
solver doesn't come up with the same solution.
Is there anybody I can send this spreadsheet to for some input?
--
-
Dilip, thank you. However, this method requires me to have 1
additional column => if the user decides to add another column just
like B, then he/she will have to copy that "supporting" column A. This
adds mess to the spreadsheet.
Thanks!
On Oct 16, 3:31 am, Dilip Pandey wro
For cRow = 3 To 99
> If Range(Addr).Value = Cells(cRow, "C")..Value Then
>Range(Addr).Font.Color = vbRed
>Range(Addr).Font.Bold = True
>Exit For
> End If
> Next cRow
> IsPresent = "&quo
?
>
> Paul
>
> ____
> From: Mark Livingstone
> To: MS EXCEL AND VBA MACROS
> Sent: Thursday, October 15, 2009 11:18:07 AM
> Subject: $$Excel-Macros$$ Re: How to match numbers from 2 columns with
> minimal formulas
>
> Paul, thank you. Unfortunately this code doesn't
"B").Value = Cells(cRow, "C").Value Then
> Cells(bRow, "B").Font.Color = vbRed
> Cells(bRow, "B").Font.Bold = True
> Exit For
> End If
> Next cRow
> Next bRow
>
> End Sub
>
Dilip, thank you! Works great but since it is conditional formatting
that uses "formula is", I can't count the # of colored cells.
http://www.cpearson.com/excel/CFColors.htm << his code doesn't work
with the "formula is" statement.
On Oct 15, 9:23 am, Dilip
Hi.
I've been trying to put together VBA code that will allow me to match
2 columns with minimal Excel formulas.
There are 2 columns. 1st column (B3 to B20) has a set of numbers. 2nd
column (C3 to C99) has another set of numbers. I need to highlight
cells in the 1st column IF the cell's content
***the formula works fine until this point, then gives me the too
many arguments error.
Thank you!
Mark
Key
final!IJ3 = number being evaluated
background!IJ$336 = average
background!IJ$343 = total credit (base credit + performance credit)
background!IJ$344 = extra credit
background!IJ$345 =
nge.
Is there a way round this? Is the Values property not supposed to be
used with just one argument? Is there a way of iterating through an
irregular range by specifying a single subscript?
N.B - I can't use a 'For Each' a
uld approach it.
Best regards
Mark
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.
27 matches
Mail list logo
