Trying to show a cost that takes place each October in a 3 year schedule. I
have a row with months 1 - 36. Row below has dates (eomonth). Normally I
have an IF statement for a one time payments. Is there a function to find
October in eomonth row?
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
The examples I found had criteria for both columns, here the criteria
> would only be applied against col B, where col A could be any value to get
> counted, provided it was unique when combined with its corresponding user
> in col B.
>
> Thanks for any help!
>
> Matt
> --
> Are
Hi, I'm using VBA to create a pivot table from a sheet with 72k rows of
data. When it was at 50-60k, the pivot worked fine but when I use more
than that I get a mismatch error at this line below
Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, _
SourceData:=PRange)
I would like to make cells under a row of several consecutive dates update to
the value of a specifically referenced cell automatically whenever the
spreadsheet is opened. Ideally, I am trying to plug in a dollar value into one
cell on a semi-regular, but not daily basis and on a separate page I
I have a formula and macro rich workbook. It has about 21 worksheets that I
work in. I mostly paste in from other excel sheets; on one sheet I extract
data from HTML through Text-to-columns and a few filters via a macro.
What I run into is that despite selecting all cells and deleting the
data(
Started to take a look, learned so much on the first page! Thanks for the
great information.
On Monday, December 9, 2013 9:45:45 AM UTC-5, anoop kumar wrote:
>
> Matt, check my blog.. i have given simple way to create macros and excel
> tricks
> www.excelautomate.blogspot.in
>
&g
Enrique Martin wrote:
>
> You need to share your file to understand your project
>
>
> On Wed, Dec 4, 2013 at 4:27 AM, Matt Watson
> > wrote:
>
>> Just a self update. I played with the Macro Recorder and managed to build
>> a macro (with some tweaking) to filter
accomplish this. On top of that I'm realizing that these macros can save me
a ton of time! I'm still open to pointers or ideas to this project.
On Tuesday, December 3, 2013 4:01:44 PM UTC-5, Matt Watson wrote:
>
>
>
> Hello all, joined this group today.
>
> I like to think I&#
Hello all, joined this group today.
I like to think I'm quite handy with excel, but the uses are so broad I may
only know 5%! I work for a car dealership and my excel skills come in handy
on a regular basis. A huge part of the business today is your website and
inventory listings. A sneaky mo
Hi Anoop,
That worked perfectly! My only question is, how did you know to name the
sheet indicies sheets 2 and 4? Since the sheets were named. I was just
wondering...
Tx again
Merry Xmas
Matt
On Saturday, December 15, 2012 11:28:03 AM UTC-5, Matt wrote:
> Hi, search the forum but could
?
Here is my updated copy, The new macro is "FindValue1"
*https://www.box.com/shared/o2dj9iju2f60ohmuvia2*<https://www.box.com/shared/o2dj9iju2f60ohmuvia2>
Thanks again for this help.
Matt
On Tuesday, December 18, 2012 1:33:10 AM UTC-5, Enrique Martin wrote:
> Hi Ma
Hi, i put the link at the bottom of. my question.
tx
here is the link with the spreadsheet
https://www.box.com/s/33z5kuabqbjn2b971ae6
matt
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Hi, i put the link at the bottom of my question.
tx
matt
--
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
x27;t seem to get the code to work unless the words are
identical. Is there anyway I can get this code to work?
The sheet is here:
https://www.box.com/s/33z5kuabqbjn2b971ae6
Tx in advance
Matt
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1)
it will show their
street, zip code, and country... can each one of those fields use a class?
I'm trying to gain applicable examples to help gain an understanding. I
have been using a few books for reference... but your explanations have
helped me jump the learning curve...
Matt
Tuesday, April 10, 2012 9:53:09 PM UTC-4, Asa R. wrote:
> Hi Matt,
>
> Glad to help. What was your solution? Moving the functions to a standard
> module instead of the class module?
>
>
>
> Asa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
&
Thanks Asa. Your advice helped! I thought I tried it before but I guess I
missed something and it works now.
Tx again'
Matt
On Thursday, April 5, 2012 3:27:51 PM UTC-4, tag wrote:
>
> please see...
> Sub or Function not defined (Visual Basic)
>
> A *Sub* or *Function
te it into its own module..
Any help would be awesome!
Tx again.
Matt
On Thursday, April 5, 2012 2:56:14 PM UTC-4, Matt wrote:
> Hello, I'm trying to call a public function in one module from another Sub
> procedure in another module and it won't call the the function. I ge
n't seem to find the answer online...
What is the problem?
Thanks again for your help.
Matt
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need A
Hello, I was trying to open an worksheet in an email and read data
from that worksheet.
Does anyone know if that is possible?
thanks in advance,
Matt
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
of mine to find aq3
> '=OFFSET(A1,2,MATCH("scheduled interest",1:1,0)-1)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Matt
> Sent: Friday, February 17, 2012 10:40 AM
> To: MS EXCE
gt;
>
>
>
>
>
> -Original Message-
> From: Matt
> Sent: Friday, February 17, 2012 9:26 AM
> To: MS EXCEL AND VBA MACROS
> Subject: Re: $$Excel-Macros$$ Creating and naming multiple ranges
>
> Hi Don, why do you believe this is a bad idea? I'm just curi
Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Matt
> Sent: Friday, February 17, 2012 8:50 AM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Creating and naming multiple ranges
>
> Hello, I have a spreadshe
Hello, I have a spreadsheet and It has many columns and I want to
create a range for each column automatically and name it based on the
value at the top row. Unfortunately, this code i created doesn't work.
Can anyone help me fix this code?
Any help would be great!
Sub test()
Dim icol As Intege
I would like to add a list item to an html control from Excel
VBA using the HTMLDocument model. I have been able operate on text
boxes, buttons, but not been able to add an item to a control
(i.e. standard html control).
I can't find any decent documentation on the HTMLDocument, so any
assistanc
25 matches
Mail list logo
