Notes :-
The workbook will contain close to 200 individual sheets and
one summary sheet. The data in the summary sheet will be given to me by
individual
teams and I will need to look at the summary sheet.
Requirements :-
ns-serif size=2 style=font-size:10pt; color=#00
Notes
its perfect! thanks a lot... :)
Sent by Outlook for Android
On Mon, Jul 27, 2015 at 5:02 AM -0700, ashish koul koul.ash...@gmail.com
wrote:
use application.enableevents = false at the beginning
and application.enableevents = true at end
On Mon, Jul 27, 2015 at 5:29 PM, gargee
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Cells.Count = 1 Then
If Target.Address = $K$2 Then
' ADD UR CODE HERE
End If
End If
Application.EnableEvents = True
End Sub
On Mon, Jul 27, 2015 at 5:54 PM,
absolutely perfect now. thanks a lot. :) :)
Sent by Outlook for Android
On Mon, Jul 27, 2015 at 5:27 AM -0700, ashish koul koul.ash...@gmail.com
wrote:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Cells.Count = 1 Then
If
Thank you, Jayaraju.M! Your code works great! Thank you again, I
appreciate you help.
The Best,
MikeB
On Sunday, July 26, 2015 at 3:09:44 AM UTC-5, Jayaraju Metta wrote:
Hi Mike,
Below is the code to find string and paste it into desired cell.
Please find the attached excel file.
'Code
Hi Partner,
Please send resume to ma...@genuineitllc.com
*Title : Business Analyst*
*Location : Austin , TX—LOCALS *
*Minimum Requirements:*
Years
Skills/Experience
8
Experience in Information Technology (IT) within the *Healthcare* business
domain.
7
Experience as a business
use application.enableevents = false at the beginning
and application.enableevents = true at end
On Mon, Jul 27, 2015 at 5:29 PM, gargee singh garge...@hotmail.com wrote:
Dear Experts
I wrote a code to multiply or divide a range of numbers by 1000 if
depending on whether a user selects
Hi Partner,
Please send resume to ma...@genuineitllc.com
*Title : Project Manager*
*Location : Austin, TX---LOCALS PREFERED*
Years
Skills/Experience
4
Applying queuing theory to business processes
4
Conducting business process improvement projects
3
Executive Decision Support
3
Hello,
i just realized that it also runs the code when i change some other cell on the
sheet e.g i use some other validation on the sheet or calculate something
elsewhere , why would that happen.
i want it to run the code only when cell k2 is changed to a yes or no.
thanks again.
Sent
I think you need to work through some of your logic and techniques.
First of all, I'd recommend using Option Explicit at the first of all code
modules.This ensures that all variables are declared.(you can set this as
default using Tools-Options and select Require Variable Declaration)
With this
Dear Experts
I wrote a code to multiply or divide a range of numbers by
1000 if depending on whether a user selects a yes or no from a drop down in
cell k2 in the active sheet. The problem
is that once I select “yes” or “no” the code loops indefinitely because it
finds a yes or no in the
So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the
column for May 1, 2016 on the Summary sheet (column G) will be populated?and
it will be a sum of all sheets in which the first column matches the date
selected?In your example, even though sheets A and C have a
Hi Partner,
Please send resume to ma...@genuineitllc.com
*Title :Cloud Specialist *
*Location :Houston TX*
*Job Description:-*
This is a “Hands On” role and will be a combination of *SysOps and DevOps
practices.* The ideal candidate will have past experience working as a *systems
engineer*
Hi All,
Please send me resume to ma...@genuineitllc.com
*Title :QA Test Lead (UFT, ALM)*
*Location: Colorado Springs CO*
*Duration: 6 months*
Interview:
1st interview –Technical Interview – Phone
2nd interview – Client Phone interview
3rd interview – Client CISCO WEBEX interview
Hi All,
Please send resume to ma...@genuineitllc.com
*Title : Hyperion *
*location :Denton, TX *
*Duration : 12 months*
Denton is in the Dallas area..
JD:-
Client confidential .but here are some details:
· Hyperion DRM resource and cash Management.
· eBTax a plus.
Hi All
We have planned some execution of test cases daily. I would like to have
the test conditions planned till date in a cell. For example in the
attached sheet for reference
we have dates from D2:V2 and corresponding test cases planned under each
date for Sub process.
Now if we take
Hi Partner,
Please send resume to ma...@genuineitllc.com
*Title: **SAP IT Banking Specialist*
*Duration: **6 months *
*Location: New York *
*Rates: *Open, but send me only qualified resumes. Good communications
skills
*PURPOSE OF THE POSITION*
Under the general guidance and supervision
Hi Partner,
Please send resume to ma...@genuineitllc.com
*Job Title: - SQL Server Developer / DBA with data conversion
experience*
*Location: - Montgomery, AL*
*Duration: - 24 Months plus*
ROLE: Data Conversion Consultant
RESPONSIBILITIES:
- Guiding the overall
Dear Paul,
Good morning and Thank you for the reply. I will try and explain this in a
better way.
If a user selects May -16 as the month of start in summary sheet (Cell E) all
columns from column G onwards will be updated in the summary sheet.
the value updated will be a sum of values from all
check this out
Public Sub test()
Dim dt As Variant
dt = Sheets(1).Cells(3, 4)
MsgBox dt
A = Application.Match(dt, Range(B2:EP2), 0)
MsgBox (A)
End Sub
Regards,
Mandeep Baluja
On Sunday, July 26, 2015 at 5:00:04 PM UTC+5:30, Mohamed Elamrani wrote:
Sorry for bothering you i'm new
20 matches
Mail list logo