--------------------------------------------
On Wed, 12/20/17, David Lanman <david.lanm...@gmail.com> wrote:
Subject: Re: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 4
updates in 3 topics
To: excel-macros@googlegroups.com
Date: Wednesday, December 20, 2017, 1:56 AM
How about simply copy
and paste values and do it to the the whole
sheet?Sub CopyPastVal()
Cells.Copy Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
Application.CutCopyMode = FalseEnd
SubThanks, David
On Tue, Dec 19, 2017
at 3:31 PM, <excel-macros@googlegroups.com>
wrote:
excel-macros@googlegroups.com
Google
Groups
Topic digest
View
all topics
Urgent Need Business Analyst 2 (Columbus OH) 06+
Months -
1 Update
Excel Macro Help -
2 Updates
Help with replacing formula with value over large
range -
1 Update
Urgent Need Business Analyst 2 (Columbus OH) 06+
Months
Javeed Khan <javed.businessanalyst@gmail.
com>: Dec 19 01:53PM -0500
Please share profile on ja...@nestarit.com
Direct contact number: (201) 448 1184
This is *Javed Khan* from *NESTAR TECHNOLOGIES/ AESPATECH
LLC* and we have
an immediate requirement with our client where we have
excellent hold and
can close the positions pretty quick. If you find yourself
comfortable with
the requirement please reply back with your updated resume
and I will get
back to you or
I would really appreciate if you can give me a call back at
my contact
number.
We have a Requirement *Business Analyst 2 / BA2* position in
*Columbus OH*.
If you have any matching resumes for the below mentioned
position.
VERY URGENT AND IMMEDIATE NEED
Job Title: Business Analyst 2 / BA2
Location: *Columbus OH (Local)*
Duration: 06+ Months Contract
*Interview: INTERVIEW ONSITE ON WEDNESDAY*
The Business Analyst is responsible for the set of tasks and
techniques
used to work as a liaison among stakeholders in order to
understand the
structure, policies, and operations of an organization, and
to recommend
solutions that enable the organization to achieve its
goals.
*Requirements:*
• *Four to six years of experience with the
following:*
• Experience creating and coordinating technical
documentation
preparation and distribution for processes, projects and
procedures.
• Experience gathering, analyzing information
needs and functional
requirements from stakeholders, business owners, and
customers.
• Experience analyzing user needs and existing
functions to
determine business requirements, screen and interface
design, use cases.
• Experience providing ongoing system maintenance
and evaluation of
systems.
• Experience delivering project artifacts.
• Experience analyzing business requirements using
interviews,
document analysis, and workshops.
• Analyzes, reviews, and recommends possible
solutions to
identified business problems.
• Develop test scripts, test cases, for User
Acceptance Testing
(UAT) based on requirements.
• Act liaison between business units, customers
(internal and
external) and various stakeholders.
• Assist Project Manager in project planning and
developing project
task plans, leading JAD sessions.
• Work experience in creating and coordinating
technical,
functional and business requirements for processes, projects
and procedures.
• Excellent communication both oral and written.-
REQUIRED
------------------------------ -------
*Warm Regards,*
Javed Khan (Sr. Technical Recruiter)
*NESTAR TECHNOLOGIES/ AESPATECH LLC*
Direct: (201) 448-1153
Email: ja...@nestarit.com
Skype ID: javeedkhan.khan2
GTalk: javeedimrank...@gmail.com
; javednesta...@gmail.com
www.nestarit.com
*Notice of Confidentiality:*
The information contained herein is intended only for the
confidential use
of the recipient. If the reader of this message is neither
the intended
recipient, nor the person responsible for delivering it to
the intended
recipient, you are hereby notified that you have received
this
communication in error, and that any review, dissemination,
distribution,
or copying of this communication is strictly prohibited. If
you receive
this in error, please notify the sender immediately by
telephone, and
destroy this e-mail message OR reply with the subject
*“REMOVE”* such that
your email would be taken out of our distribution list.
Back to top
Excel Macro Help
Julienne Schindler <julienneschind...@yahoo.com>:
Dec 19 12:29AM
------------------------------ --------------
On Mon, 12/18/17, V <vianeyespinosa@nvo2.
grandluxxe.com> wrote:
Subject: Re: $$Excel-Macros$$ Excel Macro Help
To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com
>
Date: Monday, December 18, 2017, 7:56 PM
Hi, do you know how
can I get using validations in Google Drive that change
the
color by codes.
El miércoles, 11 de octubre de 2017, 11:40:37 (UTC-5),
GENIUS escribió:look at the
attachment, I can do only this.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
Facebook page of this forum @ https://www.facebook.com/
discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
titles,
like Please Help, Urgent, Need Help, Formula Problem, Code
Problem, and Need Advice will not get quick attention or
may
not be answered.
2) Don't post a question in the thread of another
member.
3) Don't post questions regarding breaking or
bypassing
any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not
allowed.
NOTE : Don't ever post confidential data in a
workbook.
Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to
the
Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to excel-macros+unsubscribe@
googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/
group/excel-macros.
For more options, visit https://groups.google.com/d/
optout.
ublicul va lua cunostinta de ele abia in anii '80 ai
secolului nostru ele
Kenyatta Freed <kenyattafr...@yahoo.com>:
Dec 19 05:16PM
------------------------------ --------------
On Tue, 12/19/17, 'Julienne Schindler' via MS EXCEL
AND VBA MACROS <excel-macros@googlegroups.com
> wrote:
Subject: Re: $$Excel-Macros$$ Excel Macro Help
To: excel-macros@googlegroups.com
Date: Tuesday, December 19, 2017, 3:29 AM
------------------------------ --------------
On Mon, 12/18/17, V <vianeyespinosa@nvo2.
grandluxxe.com>
wrote:
Subject: Re: $$Excel-Macros$$ Excel
Macro Help
To: "MS EXCEL AND VBA MACROS" <excel-macros@googlegroups.com
>
Date: Monday, December 18, 2017, 7:56
PM
Hi, do you know how
can I get using validations in Google
Drive that change the
color by codes.
El miércoles, 11 de octubre de 2017,
11:40:37 (UTC-5),
GENIUS escribió:look at the
attachment, I can do only this.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
in Excel? And do you
wanna be? It’s =TIME(2,DO:IT,N:OW) !
Join official
Facebook page of this forum @ https://www.facebook.com/
discussexcel
FORUM RULES
1) Use concise, accurate thread
titles. Poor thread titles,
like Please Help, Urgent, Need Help,
Formula Problem, Code
Problem, and Need Advice will not get
quick attention or may
not be answered.
2) Don't post a question in the thread
of another
member.
3) Don't post questions regarding
breaking or bypassing
any security measure.
4) Acknowledge the responses you
receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and
their links is not
allowed.
NOTE : Don't ever post
confidential data in a workbook.
Forum owners and members are not
responsible for any loss.
---
You received this message because you
are subscribed to the
Google Groups "MS EXCEL AND VBA
MACROS" group.
To unsubscribe from this group and
stop receiving emails
from it, send an email to
excel-macros+unsubscribe@
googlegroups.com.
To post to this group, send email to
excel-macros@googlegroups.com.
Visit this group at
https://groups.google.com/
group/excel-macros.
For more options, visit
https://groups.google.com/d/
optout.
ublicul va lua cunostinta de ele abia
in anii '80 ai secolului nostru ele
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)
!
Join official Facebook page of this forum @ https://www.facebook.com/
discussexcel
FORUM RULES
1) Use concise, accurate thread titles.
Poor thread titles, like Please Help, Urgent, Need Help,
Formula Problem, Code Problem, and Need Advice will not
get
quick attention or may not be answered.
2) Don't post a question in the thread
of another member.
3) Don't post questions regarding
breaking or bypassing any security measure.
4) Acknowledge the responses you
receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and
their links is not allowed.
NOTE : Don't ever post
confidential data in a workbook. Forum owners and members
are not responsible for any loss.
---
You received this message because you
are subscribed to the Google Groups "MS EXCEL AND VBA
MACROS" group.
To unsubscribe from this group and stop
receiving emails from it, send an email to excel-macros+unsubscribe@
googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at
https://groups.google.com/
group/excel-macros.
For more options, visit
https://groups.google.com/d/
optout.ascoala d<n 190? si vo-'-ih i. v>teSc
sale In v>-h > socia!-poiitrca a maniei.Rascoala din
1907 a constituit apogeul miscarilor sociale de la finele
>cii modeme ce s-a remarcat printr-o amploare
intensitate grad de violenta irindere si caracter exploziv
fara precedent. Unii contemporani au intrevazut a un
veritabil razboi taranesc ce a impus cu stringenta
necesitatea rezolvarii blemei agrare.
Back to top
Help with replacing formula with value over large
range
Ravi K <rk5...@gmail.com>:
Dec 18 11:26PM -0800
Sub chkdt()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Dim rw, cl, i, q As Double 'rw - no of used rows, cl -
no of used column, i
- lookup for row,q - lookup for column
Dim dif, t, dt As Long
t = 4
dt = 5
rw = ThisWorkbook.Sheets("MINUTES")
.Range("A" & Rows.Count).End(xlUp).Row
cl = ThisWorkbook.Sheets("MINUTES")
.Range("A1").End(xlToRight). Column
ThisWorkbook.Sheets("MINUTES") .Range(Cells(8, 2),
Cells(rw, cl)).Clear
For q = 2 To cl ' column lookup
For i = 8 To rw ' row loookup
dif = Round((ThisWorkbook.Sheets("
MINUTES").Cells(dt, q) -
ThisWorkbook.Sheets("MINUTES") .Cells(t, q)) * 24
* 60, 0) - 1
If (ThisWorkbook.Sheets("MINUTES" ).Cells(i,
1) >=
ThisWorkbook.Sheets("MINUTES") .Cells(t, q)) And
_
(ThisWorkbook.Sheets("MINUTES" ).Cells(i,
1) <
ThisWorkbook.Sheets("MINUTES") .Cells(dt, q))
Then
DoEvents
ThisWorkbook.Sheets("MINUTES")
.Range(Cells(i, q), Cells(i + dif,
q)) = 1
i = rw
End If
Next i
Next q
MsgBox "completed"
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
End Sub
======================
Thanks to everyone who helped
Cheers
Ravi
On Saturday, December 16, 2017 at 11:44:17 AM UTC+5:30, Ravi
K wrote:
Back to top
You received this digest because you're subscribed
to updates for this group. You can change your settings on
the group membership
page.
To unsubscribe from this group and stop receiving
emails from it send an email to excel-macros+unsubscribe@
googlegroups.com.
--
Thanks,
David
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official
Facebook page of this forum @ https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles,
like Please Help, Urgent, Need Help, Formula Problem, Code
Problem, and Need Advice will not get quick attention or may
not be answered.
2) Don't post a question in the thread of another
member.
3) Don't post questions regarding breaking or bypassing
any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not
allowed.
NOTE : Don't ever post confidential data in a workbook.
Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the
Google Groups "MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
entiem de alte culturi europene? pana unde merge inrudirea noastra spirituala
cu alte natiuni si unde apare elementul caracteristic diferenta specifica? ce
aducem original in cultura Europei si care este obarsia acelor trasaturi care
ne singularizeaza fara a ne izola totusi?. Aceasta problematica pe care o
prefigurau cateva personalitati active in deceniile precedente Vasile
Alecsandh ca folclorist Bogdan Petriceicu Hasdeu in studii de istorie
etnografie si lingvistica Nicolae Densusianu in Dacia preistorica capata
amploare dupa implinirea vechiului vis al unitatii nationale materializandu-se
in creatii care la prima vedere cu greu se pot plasa sub acelasi stindard.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
