PFA, if you are looking for this.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of N.Shivkumar
Sent: Monday, June 16, 2014 11:13 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Conditional formatting
Dear friends
Can anybody throw
Dear Vaibhavji
If the achievement is 100% it should green arrow up, if it is less than
90% it should show red arrow down and if between 90 and 100 it should show
straight arrow.
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
On 16
Exactly and thanks for your reply
N.SHIVKUMAR
Mobile : +919422613567
Office : +912332301775
Alternate Email: shiv1...@yahoo.com
On 16 June 2014 11:54, Ravinder ravinderexcelgr...@gmail.com wrote:
PFA, if you are looking for this.
*From:* excel-macros@googlegroups.com
Sham, I tried the steps below and tried to open the workbook in Excel and
got the dialog box that states Excel found unreadable content in FILE
NAME.xlsm. Do you want to recover the contents of this workbook? If you
trust the source of this workbook, click Yes. After clicking Yes, it shows
the
Hi Team,
Your valuable replay on this will be appreciated.
Regards
On 6/15/14, Jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I want to fetch data from one sheet to another sheet by referring the data,
Attached sheet will explain you what i want exactly.
Request all of you to kindly help
Hey
How do you want to fetch? Formula or Macro?
On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta jocky6...@gmail.com wrote:
Hi Team,
I want to fetch data from one sheet to another sheet by referring the
data, Attached sheet will explain you what i want exactly.
Request all of you to kindly
Guys:
I started with the same response, until I noticed that
I believe what he's saying is that the value in the cell is NOT an Excel date:
He said: Now it is not in system's date format
so, he cannot change the display format to display it in another date format.
the solution using the
Hi vaibhav,
Fist upon thanks for the reply. I will prefer both the way
It would be very helpful If u help me on the same.
Regards
On 6/16/14, Vaibhav Joshi v...@vabs.in wrote:
Hey
How do you want to fetch? Formula or Macro?
On Sun, Jun 15, 2014 at 11:27 PM, Jocky Beta
Please respond to gurjant.si...@damcosoft.com
*Position: QA ManagerLocation: Charlotte,NCDuration: 6+ Months*
JD:
We are looking for a resource who has worked in a team to setup best
practices for testing in .Net/AngularJS/Tibco/PL SQL.
Thanks and Regards,
Gurjant Singh - (Gary)
I've been gone for a long while and forgot some of what little I knew about
proper VBA syntax. This is an easy one, I'm sure, so would someone kindly
help me with the proper syntax on the if and goto statements? I'm getting
things about end ifs without block ifs, etc. Thanks much, Dean. I
What you're describing is reminscent of some old Fortran style IF statments.
In VBA you CAN use goto's, but it's not really all that common.
In fact, I think they're only keeping them around for backward compatibility.
I THINK the equivalent to what you've described is:
If RangeName1 16
Thanks Paul, but I tried this, I think, before posting. Even though
rangename2 is 16, it is getting hung up on one of the steps that I expect
it to take only if it is less than 16. Perhaps I need to declare that the
rangenames are integers within the VBA macro, or something like that - do
Wait... just be clear...
Are you using RangeName1 as a variable that contains the name of a Named Range?
or is RangeName1 the name of a range?
also, I can see why it might have a problem with:
Selection.SpecialCells(xlCellTypeFormulas, 16).Select
since I have no idea what that line is
HI
Since date format is not the same excel can search directly what you want,
however macro in attached sheet can help you to fetch data one by one. You
need to keep open sheet 1 sheet 2 (Only 2 sheets). Goto sheet 2 workbook,
hit that blue button select the date which is in sheet one in column
I'm not sure what you are asking about the range names. I assigned each to
a group of cells in a row, cells that detect if the column is empty or not.
The macro, which hides columns that are empty, works fine as long as the
value is not 16. In that case, no columns are empty and the formula
OK, the syntax:
if Range(rangename2).Value = 16
fixed everything. Thank you very much Paul.
Dean
On Monday, June 16, 2014 11:43:06 AM UTC-7, dea...@aol.com wrote:
I've been gone for a long while and forgot some of what little I knew
about proper VBA syntax. This is an easy one, I'm sure,
16 matches
Mail list logo