d to clients. I need to accomplish using an iMac
running excel 2016.
Thank you, Vikas!
On Tuesday, August 18, 2015 at 5:02:03 PM UTC-5, Mike B wrote:
>
> I would appreciate if someone would look at this formula and tell me what
> I am doing incorrectly; I have a large spreadsheet called POS where I have
> different variables separated and I am tryi
I would appreciate if someone would look at this formula and tell me what I
am doing incorrectly; I have a large spreadsheet called POS where I have
different variables separated and I am trying to use IF,AND,ISERROR in
nested IF statements and Excel doesn't like what I did. Please see my
form
I would appreciate any help with creating a macro to email individual PDF
documents to each client's email that is chosen from a list matched to the
client's PDF to send as an attachment.
Thank you,
MikeB
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO
you,
Mike B
=GETPIVOTDATA("Net Terminal Income",$A$3,"dba","17 North","Reporting_Period
",1,"z_Month","Jan 2015","IGB Number","513140","Manfacturer","IGT","VGT","VGT
01")
heets("Sheet1").Cells(i, 2).Clear
> Sheets("Sheet1").Cells(i, 2).Interior.Color = "255,0,0"
> End If
> i = i + 1
> Wend
> MsgBox ("Done Successfully")
> ThisWorkbook.Save
> ThisWorkbook.Worksheets("Sheet1").Activate
>
> End S
I would appreciate any help with the following. I have a column "A" of
data containing shortened names in sheet 1 and another column "C"
containing the same names but in a much longer version on sheet 4; I was
thinking that perhaps I could somehow use the first five characters of the
short
Hi All
I am asking for advice! I have just been tasked with preparing some charts
of aggregated data. I am be asked to prepare four charts of customer
semi-monthly statements showing some revenue and trends of individual
items, then print a PDF file and email to each individual customer (a
I would like to copy this for each location and paste in front inventory
numbers in Column "A"(some begin with letters) and also in front of the
Establishment Totals: VC Count.
Then I would like to Remove the Word "Establishment" in from of the Totals:
VC Count.
Then I would like to delete the
Hi Mandeep,
I would appreciate you looking at the attached worksheet, I have written
and explanation in a comment on the worksheet explaining the issues I am
experiencing, I thought it would be easier for you to understand.
On Sunday, March 8, 2015 at 12:08:13 PM UTC-5, Mike B wrote:
> Th
Thank you, thank you so much for all your help and quick response!! I am
going to have to study my books to understand your code fully, it is so
precise and quick. Thank you again, Mandeep!
On Thursday, March 5, 2015 at 10:16:12 AM UTC-6, Mike B wrote:
>
>
>
> I try it works but
, 2015 at 10:16:12 AM UTC-6, Mike B wrote:
>
>
> I try it works but goes back to what I just did even though I moved my
> cursor down 11 rows. I would appreciate any help how to get it to advance
> to the next block that I am trying to copy and paste. I have about 7,000
>
oes move forward only does the same cells.
Sub CopyDate()
'
' CopyDate Macro
'
'
Range("C:C").Find(What:="12/??/2014", LookIn:=xlValues).Activate
Selection.Copy
ActiveCell.Offset(1, -1).Select
ActiveSheet.Paste
I try it works but goes back to what I just did even though I moved my
cursor down 11 rows. I would appreciate any help how to get it to advance
to the next block that I am trying to copy and paste. I have about 7,000
rows of data to do.
Thank you
Mike B
Sub just_dates2()
'
' j
14 matches
Mail list logo