Any takers - or is this more difficult than I think & too difficult of a
challenge ?
On Friday, 20 January 2017 18:21:20 UTC-5, Bill Q wrote:
>
> Anyone ??
>
> On Sunday, 15 January 2017 15:16:09 UTC-5, Bill Q wrote:
>>
>> Hi,
>>
>> PSA and link be
Anyone ??
On Sunday, 15 January 2017 15:16:09 UTC-5, Bill Q wrote:
>
> Hi,
>
> PSA and link below.
>
> Not certain if it is possible, but I am looking for code that will easily
> allow me to import this information into Excel. Preferably with the
> corres
ith ~*~*
>
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ----
Hi,
I have a large list with part descriptions. We use two asterisks at the
beginning of a part number as a special internal message. In Excel I cannot
find a way to filter two asterisks together as it is obviously treating it
as a wildcard.
How can I get around this ?
Thanks.
--
Are you
Hi,
PSA and link below.
Not certain if it is possible, but I am looking for code that will easily
allow me to import this information into Excel. Preferably with the
corresponding photo associated with the product - but not necessary if it
is an issue.
For this particular week - there are
means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -----
>
>
> On Wednesday, November 2, 2016 10:22 AM, Bill Q <ronsm...@gma
Perfect. Formula is fantastic. Macro not necessary.
Thanks again !
On Saturday, 17 September 2016 23:12:03 UTC-4, Bill Q wrote:
>
> Please see attached.
>
> Looking for a macro to automate a repetitive task.
>
> 1. It is to look for a specific text in Column C. In t
Please see attached.
Looking for a macro to automate a repetitive task.
1. It is to look for a specific text in Column C. In this case, it would be
the word "GEORGE"
2. Once it encounters the word, Column B would be populated with "X".
3. The "X" would continue to be populated until it column C
Perfect !
Many thanks !!!
On Thursday, 15 September 2016 08:41:43 UTC-4, a.gowri wrote:
>
> Updated
>
> On Thu, Sep 15, 2016 at 5:43 PM, Bill Q <ronsm...@gmail.com >
> wrote:
>
>> Incredible. The formula is way too complex for me. Nice work. However,
Incredible. The formula is way too complex for me. Nice work. However,
there seems to be an error in the coding or. Please refer to sets # 13, 14
& 28 (I am certain there are others.
On Wednesday, 14 September 2016 15:53:40 UTC-4, Bill Q wrote:
>
> P.S.A.
>
> I just can't
Hi Paul,
Yes, this us what I was looking for. After not getting any replies from
anyone (and spending way too much time on it), I also came up with a
similar solution.
1. TEXT(A1,"yymmdd")
2. The in adjacent cell =A1*1
Thank you.
On Wednesday, 8 June 2016 20:09:53 UTC-4, Bi
Anyone ??
On Wednesday, 8 June 2016 20:09:53 UTC-4, Bill Q wrote:
>
> Hi,
>
> PSA.
>
> Column "A" = source.date.
> Column "B" = source date converted to special date form MMDD
>
> I would like column "C" to be just the numeric. .
&
Hi,
PSA.
Column "A" = source.date.
Column "B" = source date converted to special date form MMDD
I would like column "C" to be just the numeric. .
I have tried just about everything.
Cannot figure this out.
Any takers ?
Much appreciated.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Hi,
PSA.
Trying to do a simple vlookup. I cleaned up the data by trimming, but still
cannot get a match.
I manually entered in data in B2 in order to get a match.
I never encountered anything like this before. Not certain how to fix.
Anyone ?
Thanks.
--
Are you =EXP(E:RT) or
Hi,
The link in question is below.
http://contests.covers.com/KingOfCovers/Contestant/CompletedPicks/0c459c57-a44f-4aed-9104-a5de00e4c7ea
Once you go into this link - you will see part of the page looks like
below.
On the far right you have a hyperlink for each record. Unfortunately, this
Sill question - cannot find solution.
How can one keep the conditional formatting on a pivot table when filtering
? As strange as it sounds, I even loose the conditional formatting once I
filter.
I am using Excel 2013.
Thanks.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Hi,
Is there anyway to easily filter filters in a pivot table ? Often my pivot
tables contain multiple items in the filter, and I find it very inefficient
to have to manually check off multiple items.
I am looking for more or less a "greater than" or "less than" option that
would filter
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Monda
the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Sunday, February 21, 2016 4:27 PM, Bill Q <ronsm...@gmail.com
> > wrote:
>
>
>
> PSA.
>
> Cannot figure out how to
PSA.
Cannot figure out how to fix this or change settings so that the date is
consistent.
The dates on attached are downloaded from the web. Once imported, they
change format.
The dates in this should be between Oct 2015 and Feb 2016.
I have tried various system and excel date settings -
Not sure what you did but it works beautifully.
Thank you Mandeep.
On Sunday, January 31, 2016 at 8:00:29 PM UTC-5, Bill Q wrote:
>
> PSA
>
> Not sure how to tackle this one.
>
> Simple list attached.
>
> * Column "B" & "C" in yell
PSA
Not sure how to tackle this one.
Simple list attached.
* Column "B" & "C" in yellow is the source.
* Column "G" are the values to compare to column "B"
* If "B1" = text from anywhere in "G" - then "A1" is to be populated by "B1"
Here is where I get confused...
- Afterwards it checks
Thank you Mandeep !
On Monday, 4 January 2016 10:45:11 UTC-5, Bill Q wrote:
>
> PSA...
>
> There are two sheets attached
>
> * Sheet "INV" (the main sheet)
> * Sheet "CONTAINERS"
>
> * Both have item # as the key.
>
> I am looking
PSA...
There are two sheets attached
* Sheet "INV" (the main sheet)
* Sheet "CONTAINERS"
* Both have item # as the key.
I am looking at somehow having The "INV" sheet pull down or access the
information from the "CONTAINERS" based only on the item #.
If there was a single container per
0+TIME(0,55,0)*1440)/1440)
>
> Cheers!!
>
> On Wed, Nov 25, 2015 at 1:44 AM, Bill Q <ronsm...@gmail.com >
> wrote:
>
>>
>>
>> I gave this my best shot - but I am not satisfied with it.
>>
>> PSA.
>>
>> * What I have are dates betw
all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Bill Q <ronsm...@gmail.com >
> *To:
I gave this my best shot - but I am not satisfied with it.
PSA.
* What I have are dates between November 15, 2015 to January 16, 2016
* Each date will have 16 radio "spots".
* These spots are to be anywhere between 07:00 to 21:00.
I was able to randomize the time somewhat with the final
Close but know. All dates in the "source" are actually in 2015. See my
dilemma ?
On Sunday, 22 November 2015 22:40:48 UTC-5, Bill Q wrote:
>
>
>
> PSA.
>
> Can someone please create a macro for me that would eliminate this
> frustrating problem th
;
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Bill Q <ronsm...@gmail.com >
>
I played around with my system date format and finally got it right.
Thanks Paul & Mandeep
On Sunday, 22 November 2015 22:40:48 UTC-5, Bill Q wrote:
>
>
>
> PSA.
>
> Can someone please create a macro for me that would eliminate this
> frustrating problem that I h
PSA.
Can someone please create a macro for me that would eliminate this
frustrating problem that I have with date converstion.
DATE1 = Source. It always gets imported in as 2 different date formats.
DATE2 is what I want returned in a MMDD format. I have manually change
it in this
Perfect !
Thank you Mandeep.
On Sunday, 15 November 2015 14:56:32 UTC-5, Bill Q wrote:
>
> Hi,
>
> Can someone tell me or modify this macro so that when data is returned -
> it returns the actual hyperlink whenever it encounters it, instead of
> dumping plain
Hi,
Can someone tell me or modify this macro so that when data is returned - it
returns the actual hyperlink whenever it encounters it, instead of dumping
plain text ?
Thanks.
--
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
I managed to incorporate my changes within your template. Thanks once again
Paul. It's near perfection.
On Sunday, 9 August 2015 16:55:55 UTC-4, Bill Q wrote:
Hi,
Please see attached. I am not good at coding. Hopefully, one of you can
easily do this. I believe that it is relatively easy
This is great Paul. I ended up creating something myself (PSA). The only
thing that it does not incorporate is the first line with an event macro
that you put in (a GREAT feature). Could you please insert that code inside
mine ?
Thanks,
On Sunday, 9 August 2015 16:55:55 UTC-4, Bill Q wrote
Hi,
Please see attached. I am not good at coding. Hopefully, one of you can
easily do this. I believe that it is relatively easy.
I looked at many other templates out there. Unfortunately, I found nothing
that suites my needs as much as I envision this.
PSA.
1. Row 2 is where you would
Anyone ?
On Friday, 19 June 2015 17:56:51 UTC-4, Bill Q wrote:
Hi Guys,
Attached is a spreadsheet and macro that does some web-scraping of
individual web pages..
I need two modifications on this macro that I do not know how to do as I
have little experience.
* Currently the macro
Hi Guys,
Attached is a spreadsheet and macro that does some web-scraping of
individual web pages..
I need two modifications on this macro that I do not know how to do as I
have little experience.
* Currently the macro will stop after it encounters about 32700 rows. I
would like it to run
You attachment is different than I envisioned by is VERY well done and is
completely acceptable. THANK YOU !!!
On Tuesday, 2 June 2015 12:19:32 UTC-4, Bill Q wrote:
Hi,
Ideally, I am looking for something that would look at another sheet so
that it would show all outstanding Purchase
friendly.
On Tuesday, 2 June 2015 12:19:32 UTC-4, Bill Q wrote:
Hi,
Ideally, I am looking for something that would look at another sheet so
that it would show all outstanding Purchase orders pertaining to a specific
item #. Both sheets would have the item # as the key. The dropdown would
Hi,
Ideally, I am looking for something that would look at another sheet so
that it would show all outstanding Purchase orders pertaining to a specific
item #. Both sheets would have the item # as the key. The dropdown would
need to show multiple fields pertaining to the open PO(s) on that
Thanks, but I must be doing something wrong - becuase it isn;t working for
me.
On Sunday, 29 March 2015 17:37:58 UTC-4, Bill Q wrote:
Attached is a very small sample of a much larger data set. I need to
separate the data - in this case in 3 different and separate columns. For
whatever
Attached is a very small sample of a much larger data set. I need to
separate the data - in this case in 3 different and separate columns. For
whatever reason there is what looks like a tilde between the numbers. I
cannot seem to put in the right delimiter in order to have it separated
feed
into excel and that should get you going in the right direction
On 16 March 2015 at 15:07, Bill Q ronsm...@gmail.com javascript:
wrote:
Hi Martin,
Thanks for the reply. I have no idea how to work with this. I am not
overly savvy with this ?
Can you give me any insight on how
Hi,
Normally I can do this, but I can't with this particular site starting at
this page.
- http://contests.covers.com/Handicapping/topHandicappers.aspx?sportid=9
- Each page contains 50 records.
- Somehow, something needs to be macro programed (if possible), so that it
goes to the next
://www.covers.com/rss/index.aspx
? That may be your best bet - use a xml schema to import to excel
Ta
Martin
On 16 March 2015 at 09:28, Bill Q ronsm...@gmail.com javascript:
wrote:
Hi,
Normally I can do this, but I can't with this particular site starting at
this page.
- http
Anyone ?
On Wednesday, 25 February 2015 11:41:47 UTC-5, Bill Q wrote:
Hi,
I can do this as an object - but quite frankly it is more hassle than what
it's worth.
Does anyone have a better way (with minimal steps) where one can link or
embed a specific Outlook email into an excel cell
No takers ??
On Wednesday, 25 February 2015 11:41:47 UTC-5, Bill Q wrote:
Hi,
I can do this as an object - but quite frankly it is more hassle than what
it's worth.
Does anyone have a better way (with minimal steps) where one can link or
embed a specific Outlook email into an excel
A VERY useful and great tip.
Thanks !
On Monday, 23 February 2015 10:07:10 UTC-5, Vabz wrote:
Convert all date in same format:
While receiving data from different sources many time it happens that
data received is not in same format due to various reason.
One of the tedious activity is
Hi,
I can do this as an object - but quite frankly it is more hassle than what
it's worth.
Does anyone have a better way (with minimal steps) where one can link or
embed a specific Outlook email into an excel cell without it being an
object ?
This would be a great help.
Thanks !!
--
PERFECT Paul.
Thank you very much.
On Thursday, January 22, 2015 at 12:15:30 PM UTC-5, Bill Q wrote:
Hi,
I currently use filter tabs when filtering data. It is a very useful.
However, what I would like is to have a search cell (Say A1)that
specifically would filter All cells from A3
, Bill Q wrote:
Hi,
I currently use filter tabs when filtering data. It is a very useful.
However, what I would like is to have a search cell (Say A1)that
specifically would filter All cells from A3 to A1 that contain what
ever is typed in as you type in without having to press the enter
you
can,In all the places you can,At all the times you can,To all the people
you can,As long as ever you can.” - John Wesley*
-
*From:* Bill Q ronsm...@gmail.com javascript:
*To:* excel-...@googlegroups.com javascript:
*Sent:* Thursday, January
Hi,
I currently use filter tabs when filtering data. It is a very useful.
However, what I would like is to have a search cell (Say A1)that
specifically would filter All cells from A3 to A1 that contain what
ever is typed in as you type in without having to press the enter button or
Perfect... Many thanks Vabz !
On Monday, September 1, 2014 1:56:01 PM UTC-4, Bill Q wrote:
Hi,
PSA.
I am looking for two things to be modified with this macro:
1. A timer (in seconds) when it gets into the website and extracts
(retrieves) the line information that will allow
Not working properly. Once spreadsheet is opened, the msg box shows up. 20,
30, 60 seconds pass... nothing. If I press ok I will run through it once
then stay there once again with the msg box showing until pressed again.
On Monday, September 1, 2014 1:56:01 PM UTC-4, Bill Q wrote:
Hi
. The same thing
when I run the Startclock macro.
I am running Excel 2013 with Windows 7.
Thanks.
On Monday, September 1, 2014 1:56:01 PM UTC-4, Bill Q wrote:
Hi,
PSA.
I am looking for two things to be modified with this macro:
1. A timer (in seconds) when it gets into the website
September 2014 13:56:01 UTC-4, Bill Q wrote:
Hi,
PSA.
I am looking for two things to be modified with this macro:
1. A timer (in seconds) when it gets into the website and extracts
(retrieves) the line information that will allow it to pause.
2. A second timer (in seconds) to pause before
I unfortunately cannot get it to work. Would it be possible for you to
modify the macro and attach ?
On Monday, 1 September 2014 13:56:01 UTC-4, Bill Q wrote:
Hi,
PSA.
I am looking for two things to be modified with this macro:
1. A timer (in seconds) when it gets into the website
PERFECT VABZ !
Many thanks.
On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote:
Hi Guys,
PSA.
What I am ultimately looking for is a formula that would automatically
return all the information based on three different criterias.
In cell K1 - The operator has the option
Can bé trần văn attachment be modified so that the two select criterias
also includes blanks ? This will solve my problem.
On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote:
Hi Guys,
PSA.
What I am ultimately looking for is a formula that would automatically
return all
Anyone ?? Even an alternative solution perhaps ??
On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote:
Hi Guys,
PSA.
What I am ultimately looking for is a formula that would automatically
return all the information based on three different criterias.
In cell K1 - The operator
FOLLOWING
P = Only records where cell E6 onwards 10 AND ALL BLANK RECORDS
FOLLOWING
On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote:
Hi Guys,
PSA.
What I am ultimately looking for is a formula that would automatically
return all the information based on three
Sounds great, but I unfortunately do not have the skill to do this.
On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote:
Hi Guys,
PSA.
What I am ultimately looking for is a formula that would automatically
return all the information based on three different criterias.
In cell K1
10 AND ALL BLANK RECORDS
FOLLOWING
On Thursday, 14 August 2014 10:37:09 UTC-4, Bill Q wrote:
Hi Guys,
PSA.
What I am ultimately looking for is a formula that would automatically
return all the information based on three different criterias.
In cell K1 - The operator has the option
Pramod
On Thu, Jul 17, 2014 at 7:23 AM, Bill Q ronsm...@gmail.com javascript:
wrote:
Pramod,
Would you have any idea why it stops ?
On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wrote:
A great first effort Pramod. I called it up a few times. I always get
the same 3 first lines
Pramod,
Would you have any idea why it stops ?
On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q wrote:
A great first effort Pramod. I called it up a few times. I always get the
same 3 first lines returned - then I get the following error from your code
and it stops:
wk.Cells(i, x
On Sunday, July 13, 2014 2:51:21 PM UTC-4, Bill Q wrote:
Hi,
I would like to have (hopefully) a simple code made to extra all the pages
from a URL.This URL is static and requires that a next page button be
pressed to get to the next page of data. I am not sure how easy or
complicated this is. I
Hi,
I would like to have (hopefully) a simple code made to extra all the pages
from a URL.This URL is static and requires that a next page button be
pressed to get to the next page of data. I am not sure how easy or
complicated this is. I would ideally like it to start extracting on the
spreadsheet and modify the
parameters accordingly.
Thanks.
On Sunday, 6 July 2014 13:53:24 UTC-4, Bill Q wrote:
Hi,
I meant return date/time stamp. not look.
Example:
- The date/time stamp would be in cell K1.
- If any cell between A1 and J1 are modified, K1 would automatically
Hi,
Example:
- The date/time stamp would be in cell K1.
- If any cell between A1 and J1 are modified, K1 would automatically
reflect the new date and time.
Thanks.
--
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
See attached spreadsheet.
- Starts off with time it was entered.
- Anytime a specific cell in a specific row is modified the K cell (for
that row only) would be modified with the date and time that it was
modified.
Thanks.
On Sunday, July 6, 2014 1:53:24 PM UTC-4, Bill Q wrote:
Hi
Works flawlessly Thanks again !
On Friday, May 30, 2014 5:40:46 PM UTC-4, Bill Q wrote:
Hi,
I am looking for a macro that would:
- Copy all the information from the current active worksheet that I am in
from cell A1 until it encounters the first blank in column
I spoke too soon. There is an issue
It picks up and copying all the data from column A to column D
inclusively. It is not picking up and copying data, if from column E
onwards for some reason.
Quick fix ?
On Saturday, May 31, 2014 12:35:17 PM UTC-4, Bill Q wrote:
Perfect. Thank
GoTo 0
For k = j + 1 To ActiveSheet.UsedRange.Rows.Count + 1
Cells(k, 1) = Cells(j, 1)
Cells(k, 2) = Cells(j, 2)
Cells(k, 3) = Cells(j, 3)
Next k
j = k
Worksheets(URL).Select
i = i + 1
Loop
End Sub
On Friday, May 30, 2014 5:27:09 PM UTC-4, Bill Q wrote:
Hi,
I am using
Perfect. Thank you !!
On Saturday, May 31, 2014 2:44:42 AM UTC-4, Vabz wrote:
Hi
Check Attachment.. You can goto sheet Autocopy to do the task..
Cheers!!
On Sat, May 31, 2014 at 3:10 AM, Bill Q ronsm...@gmail.com javascript:
wrote:
Hi,
I am looking for a macro that would
Hi,
I am using Excel 2010. I have a macro web query that downloads various
information. It works fine. No issue there. The only issue that I have is
that it will stop if it encounters more than 33 or 34 thousand rows of
information. I have unchecked the box in advanced options that will not
Hi,
I am looking for a macro that would:
- Copy all the information from the current active worksheet that I am in
from cell A1 until it encounters the first blank in column in A into a
worksheet already named as MAIN that is within the same workbook. It will
be thousands of lines.
- Before
.
On Friday, 9 May 2014 20:50:55 UTC-4, Bill Q wrote:
I have spent the better part of 40 minutes searching the web for what I
believe is a simple solution. I have found many answers. I have tried them
all - None are working to what I am looking for.
Simply put.
- Assume source Data
Perfect ! Thanks very much Vabz.
On Saturday, 10 May 2014 13:25:29 UTC-4, Vabz wrote:
Hi
See attached file.. Hope this is what exactly i want, i guess i am getting
what you mean by autofill..
Cheers!!
On Sat, May 10, 2014 at 8:44 PM, Bill Q ronsm...@gmail.com
javascript:wrote:
Hi
I have spent the better part of 40 minutes searching the web for what I
believe is a simple solution. I have found many answers. I have tried them
all - None are working to what I am looking for.
Simply put.
- Assume source Data is always is column A. It could be 50 rows in length
or 84,679
Please see attached file.
- Original date is Row A
- I formatted the date through custom formatting to get my desired results
(Row B). It works, but unfortunately it is only visually good - as it
is a serial number.
I just want the number as is. Suggestions please.?
Thanks.
--
Are you
PERFECT. Many thanks Priti
On Thursday, 27 February 2014 13:35:10 UTC-5, Priti_Verma wrote:
hi ,
try this formula and then paste special value.
=TEXT(A2,mmdd)
it will be convert into number.
On Thu, Feb 27, 2014 at 9:19 AM, Bill Q ronsm...@gmail.com
javascript:wrote
Yes, I am aware of that feature. It just not a clean result. Was hoping
for better alternative.
Thanks Besole.
Thanks Besole,
On Monday, January 6, 2014 5:57:20 PM UTC-5, Basole wrote:
Em segunda-feira, 6 de janeiro de 2014 20h44min15s UTC-2, Bill Q escreveu:
Hi
20h44min15s UTC-2, Bill Q escreveu:
Hi,
Is there a relative easy way to extract prices from specific Amazon URL's
? I live in Canada and use amazon.ca , but often see prices much less
expensive in the USA site (amazon.com).
I wish to compare various items where I could just easily
Hi,
Is there a relative easy way to extract prices from specific Amazon URL's ?
I live in Canada and use amazon.ca , but often see prices much less
expensive in the USA site (amazon.com).
I wish to compare various items where I could just easily refresh to see
the prices from both sites
sent me two different situations +
and -. Indicate whether the other possible situations that can occur with
other data!
regards,
Basole.
Em segunda-feira, 16 de dezembro de 2013 23h09min31s UTC-2, Bill Q
escreveu:
Hi,
The macro below currently finds and removes selected
:02:28 PM UTC-5, Basole wrote:
Hi Bill, press the F8 key on VBE (VB editor) to check what line and what
kind of character the error occurs.
Basole.
Em segunda-feira, 16 de dezembro de 2013 23h09min31s UTC-2, Bill Q
escreveu:
Hi,
The macro below currently finds and removes
Success. Flawlessly beautiful.
Many thanks again Basole !!
On Monday, December 16, 2013 8:09:31 PM UTC-5, Bill Q wrote:
Hi,
The macro below currently finds and removes selected characters that it
find. It works great. No issues.
What I would like is this to be modified so
23h09min31s UTC-2, Bill Q
escreveu:
Hi,
The macro below currently finds and removes selected characters that it
find. It works great. No issues.
What I would like is this to be modified so that if it finds a character
within the array - it will move the character in question
Hi,
The macro below currently finds and removes selected characters that it
find. It works great. No issues.
What I would like is this to be modified so that if it finds a character
within the array - it will move the character in question to the adjacent
cell to the right, THEN it will
ActiveCell.Offset(r, 1) = v
For i = 0 To 13
v = Replace(v, s(i), )
Next
r.Value = v
Next
End Sub
regards,
Basole
Em segunda-feira, 16 de dezembro de 2013 23h09min31s UTC-2, Bill Q
escreveu:
Hi,
The macro below currently finds and removes selected characters that it
find. It works great
array. But I personally prefer array solutions
only if non array solution is not available.
Regards
On Tue, Nov 12, 2013 at 10:12 AM, Bill Q ronsm...@gmail.com javascript:
wrote:
Kantila,
Thanks for your effort. I appreciate it and everyone else's
contribution. I have
I don't see anything else except your comment sure. Am I missing
something ?
On Wednesday, November 13, 2013 3:21:51 AM UTC-5, Enrique Martin wrote:
Sure
On Wed, Nov 13, 2013 at 11:06 AM, Bill Q ronsm...@gmail.com javascript:
wrote:
On Thursday, December 13, 2012 8:48:25 PM UTC-5
at the same time on Tuesday. so on
and so forth until end of day Friday.
Thanks.
On Tuesday, December 11, 2012 5:25:54 PM UTC-5, Bill Q wrote:
Hi,
Looking for code to be modified using military time if possible. I would
just go into the code and modify the time when needed.
Thanks
What does pfa mean ?
On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
pfa
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *Bill Q
*Sent:* Sunday, November 10, 2013 10:55 PM
*To:* excel
Thanks Bruce
On Monday, 11 November 2013 19:51:30 UTC-5, bruce wrote:
What is PFA?PFA is Please Find Attached
On Monday, November 11, 2013 3:49:38 PM UTC-8, Bill Q wrote:
What does pfa mean ?
On Monday, November 11, 2013 2:01:37 AM UTC-5, ravinder negi wrote:
pfa
*From
PERECT Ravinder !
MANY thanks !
On Monday, 11 November 2013 02:01:37 UTC-5, ravinder negi wrote:
pfa
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of *Bill Q
*Sent:* Sunday, November 10, 2013 10:55 PM
*To:* excel
, November 11, 2013 11:21:08 PM UTC-5, kantila...@gmail.com wrote:
PFA
Non array solution
CA Kantilal Badale
On Tue, Nov 12, 2013 at 7:33 AM, Bill Q ronsm...@gmail.com
javascript:wrote:
PERECT Ravinder !
MANY thanks !
On Monday, 11 November 2013 02:01:37 UTC-5, ravinder
Hi Guys,
This seems simple and I am pretty certain that it is - but I am stumped.
Please refer to attached.
- This is a simple price list estimator.
- There are 2 worksheets. (1 = work, that you work from) (2 = static
information/vlookup table)
I cannot figure out how to return values
1 - 100 of 130 matches
Mail list logo