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 s
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 project
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 o
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 tod
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,
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
*Tes
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 colu
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* a
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 th
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
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 analyst
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.
>
> 'C
absolutely perfect now. thanks a lot. :) :)
Sent by Outlook for Android
On Mon, Jul 27, 2015 at 5:27 AM -0700, "ashish koul"
wrote:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target.Cells.Count = 1 Then
If Target.Address = "$K$2"
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,
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 b
its perfect! thanks a lot... :)
Sent by Outlook for Android
On Mon, Jul 27, 2015 at 5:02 AM -0700, "ashish koul"
wrote:
use application.enableevents = false at the beginning
and application.enableevents = true at end
On Mon, Jul 27, 2015 at 5:29 PM, gargee singh wrote:
>
> Dear
use application.enableevents = false at the beginning
and application.enableevents = true at end
On Mon, Jul 27, 2015 at 5:29 PM, gargee singh wrote:
>
> 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 fr
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">
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 cell
19 matches
Mail list logo