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 below.
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
> corresponding p
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 20
n,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 Wednesday, November 2, 2016 10:22 AM, Bill Q > wro
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 this case,
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 >
> wrote:
>
>> Incredible. The formula is way too complex for me. Nice work. However,
>> there seems to be an err
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&#
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)) in
Thank you. It works perfectly.
MUCH appreciated.
On Sunday, 22 May 2016 06:51:12 UTC-4, Bill Q wrote:
>
> 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 o
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 =NOT(EXP
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
li
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 w
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 thing
>
>
>
>
> *“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 M
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 Sunday, February 21, 2016 4:27 PM, Bill Q > wrote:
>
>
>
> PSA.
>
> Cannot figure out how to fix this or change setti
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 - no
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 yellow
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 at s
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 item
0+TIME(0,55,0)*1440)/1440)
>
> Cheers!!
>
> On Wed, Nov 25, 2015 at 1:44 AM, Bill Q >
> wrote:
>
>>
>>
>> I gave this my best shot - but I am not satisfied with it.
>>
>> PSA.
>>
>> * What I have are dates between November 15, 2015 to Janu
*“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 >
> *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 pro
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
;
>
>
>
>
>
>
> *“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 >
> *To:* MS EXCEL AND V
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
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 exampl
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 text ?
>
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 t
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 ent
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 expe
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 to
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 outst
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
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
pa
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
&
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
properly
t;how to download rss feed
> into excel" and that should get you going in the right direction
>
> On 16 March 2015 at 15:07, Bill Q >
> wrote:
>
>> Hi Martin,
>>
>> Thanks for the reply. I have no idea how to work with this. I am not
>> overly savvy w
ttp://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 >
> wrote:
>
>> Hi,
>>
>> Normally I can do this, but I can't with this
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 page
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 s
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 s
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 activ
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 !!
--
Are
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
> specifi
, 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
e userform exits.
>
>
> *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 lon
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
g
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
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:
>
&
;macro1" directly - it does nothing. 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 w
s(j, 3)
Next k
j = k
Worksheets("URL").Select
i = i + 1
Loop
End Sub
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 we
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 second
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
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 automatic
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.
&g
ANK RECORDS
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
rds < 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.
>
&
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 thre
on it from another method.
>
> Regard
> Pramod
>
>
> On Thu, Jul 17, 2014 at 7:23 AM, Bill Q >
> wrote:
>
>> Pramod,
>>
>> Would you have any idea why it stops ?
>>
>> On Monday, July 14, 2014 7:16:58 AM UTC-4, Bill Q 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 returned - then I get the following error from your code
> and it stops:
>
&g
amp;sportID=3>
*View*
<http://contests.covers.com/sportscontests/profile.aspx?user=-7699&sportID=3>
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
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
fir
Perfect. Thanks for all your help Pramod, Ashish & Vabz !!
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.
&g
other 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.
> -
1:53:24 PM 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
> reflect the new
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 wr
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 pag
Thank you. This solved the problem.
Much appreciated !
On Friday, May 30, 2014 5:27:09 PM UTC-4, Bill Q wrote:
> 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
> th
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
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With
On Error 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 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 U
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 >
> wrote:
>
>> Hi,
>>
>>
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.
- Befor
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
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
ncounters any data in "A".
Thanks.
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 a
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
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:1
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
* $$Excel-Macros$$ Re: Amazon - Compare Prices
>
>
>
>
>
> Em segunda-feira, 6 de janeiro de 2014 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 us
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
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 for
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 t
: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:
&
had 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
> e
1), "-") - 1)
> SecontPartH = Right(Cells(i, 1), Len(Cells(i, 1)) - InStr(Cells(i, 1),
> "-") + 1)
> Cells(i, 2) = FirstPartH
> Cells(i, 3) = SecontPartH
> End If
> End If
> Next
> End Sub
> '_
> 'Basole.
>
>
> Em segunda
t;, "9")
> For Each r In Selection
> v = r.Value
> ActiveCell(1, 2) = v
> For i = 0 To 13
> v = Replace(v, s(i), " ")
> Next
> r.Value = v
> Next
> End Sub
>
>
> Basole
>
>
>
> Em segunda-feira, 16 de dezembro de 2013 23h09min31s
quot;1", "2", "3", "4", "5", "6", "7",
> "8", "9")
> For Each r In Selection
> v = r.Value
> ActiveCell.Offset(r, 1) = v
> For i = 0 To 13
> v = Replace(v, s(i), " ")
> Next
> r.Va
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 cle
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
> > wrote:
>
>>
>> On Thursday, De
rray solutions are very
> powerful compared to non 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
> > wrote:
>
>> Kantila,
>>
>> Thanks fo
t 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
1 - 100 of 138 matches
Mail list logo
