Macro for Autofiltering certain dates
Summary per month is in column A, the month and year are in columns B
and C respectively.
in row 1 (columns H and I) I have the =DATE function to say what month
it is. Using these variables I wish to autofilter the A:C column data
for the latest month so I can present the latest column A number. I
need the data criteria to check the latest A:C data has been imported
for that month.
Set Retail = Workbooks.Open("N:\mis\EXCEL\EoM\DW-Reports
Set Retailtest = Workbooks.Open("N:\mis\EX...Bcc field #2
I've lost the email fanclublist of our site (http://www.conniekennie.nl).
All I can do is look if I can read the bcc-field of a previous email. Is
there a way to see the email addresses in this field (with a little tiny
Can someone help me?
Thank you in advance,
are they messages you sent as BCC? If so, you can see the list on the
message in the Sent folder. if someone BCCd you, you can't see the list of
who was BCCd.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in ...2 Workflows
I need to create a workflow that, when a field is populated in one entity,
will create an Alert prompt to the user as a reminder that they need to edit
a field on another entity.
And I would also like to know how to create a workflow that will, when a
field is populated in one entity, create a new record for another (related)
Is this possible? Thank you very much.
On Aug 17, 6:49=A0am, Bernardina <d...@discussions.microsoft.com> wrote:
> I need to create a workflow that, when a field is populated in one entity=
> will create an Alert prompt to the user as a reminde...Formula for calculating # of days between dates minus a particular date if present
I'm trying to create a formula that will calculate the number of days
between two dates automatically subtracting a day(s) from the equation
if a specified date(s) falls in between the two dates.
For example, I don't want 1/15/04 to register as a counted day. If I
enter the dates 1/1/04 in one cell and 1/12/04 in another cell then
it's a straight foward DATEDIF equation. But if I enter 1/1/04 and
1/28/04, then I want the formula to figure out the number of days
between 1/1 and 1/28 automatically subtracting 1/15 from the equation.
This gets trickier as I need some calucations th...rounddown with date calc?
I'm trying to determine the number of years someone has on the job.
I'm using this formula - =DATEDIF(B7,TODAY(),"m")/12.
This gives me a result of 13.92, how can I round down this calculatio
If I remove the decimals...it rounds up to 14 - which is an error.
Ltat42a's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2473
View this thread: http://www.excelforum.com/showthread.php?threadid=49837
> I'm trying to determine the n...Planning to Upgrade Great Plains eEnterprise 6.0 to version 9.0
Hi Planning to upgrade from version eenterprise 6.0 running on SQL7.0 to
Dynamics 9.0 on SQL 2005 anyone has done it? if so please post.
We have done it several times already.
We can do it for you.
> Hi Planning to upgrade from version eenterprise 6.0 running on SQL7.0 to
> Dynamics 9.0 on SQL 2005 anyone has done it? if so please post.
I have done upgrades from 6. to 9.0
Always print reports before and after each version upgraded and compare.
Backup the Reports Dictionary.
Create a package file...Conditional Format Tracker by Date
I'm building a tracker to make sure paperwork is done on time.
I'd like to use conditional formatting to compare the dates and color the
cells for easier tracking.
The compare TO date is column D.
In column E, we have 7 days to write the plan so if there is no date in that
column, turn red. When a date is entered turn green if within 7 days but
yellow if it's past 7 days.
In column F, same as column E but only 3 days for that one. (I can figure
that out if I get a w...Date.
I notice that when I put a date and drag the little square in the bottom
right of the cell to adjacent cells, the other cells will have a date
increment by one day. However, how do I do this when the cell is not
adjacent and far apart?
Another question, If I have two cell that are not adjacent and I want to add
the date (9-23-04) for the beginning of the week which is Monday and the
date for the end of the week which is sunday, How do I do this with 7 days
range but within only two 2 cells?
use a formula such as
and copy this formula
...Graph With 2 Sources
Is there a way to create a graph which gets it's source data from 2+ worksheets? Each worksheet charts the same kind of data. The x-axis length does vary but I don't mind manually entering the cell references.
Look at Charting Data From Different Sheets:
You can't put data from different sheets into the values for a single
series. My question for you: if you don't mind manually entering cell
references, why haven't you just linked cells in a third worksheet to
the cells in the first two, and pl...paste charts into powerpoint-misalignment
i have an excel program which pastes excel charts into powerpoint. on certain
excel charts ( i paste the entire page) the page that i wish to paste into
ppt, consists of graphs as well as pictures on the same sheet. When I paste
it into powerpoint via vba code, the pictures (not the charts) seem to come
misaligned. they shift to the left on the powerpoint slide. do you have an
idea what might be causing this misalignment.
...email recovery #2
i just recently reformated my computer to the extentent
of no lossage of files on my computer. everything was
retained except the files. my isp said they should be
still on my computer but dont know the extension to the
files. i was wondering how i could recover these files.
my os is win xp,office 2000, outlook 2000.
outlook 2000 email, contacts, calendar, .etc is stored in a file with *.pst
extension. default location is in a hidden directory under one of the
\documents and settings\<userid>\application data\microsoft\outlook
\documents and settings\<u...Exchange tabs missing on 2 other 2003 DC's
I have a simple question (I hope)
I used to have a 2000 GC with exchange 2000 on it. I have now moved to a
2003 domain and have migrated to Exchange 2003. This is all on 1 server, and
I know "now" that having the GC on the Exchange server is not a good idea
(but we all make due on a limited budget). I have just recently added 2 DC
in a hope to move the GC off of the exchange server.
Here is my question: Why are the Exchange tabs missing from the 2 other
DC’s? I was under the impression that I did not have to install the Exchange
management tools on the other DC’s. If this...Outlook Client Error #2
I have one user that is receiving the following error after installing the
CRM 4.0 Outlook client.
"Your server administrator has limited the number of items you can open
simultaneously. Try closing messages or removing attachments and images from
unsent messages you are composing."
This happens after using Outlook for a few minutes. If I remove the client
the error will stop appearing. She is using Outlook 2007 on windows XP. I
have applied Hotfix kb970944 and all applicable updates to Outlook. The user
dose have a large amount of emails in her inbox, but I have other u...Outlook slow saving attachments to nt 4.0 server
After upgrading to Windows XP Professional, Outlook 2000
is extremely slow in saving attachments to a Windows nt
4.0 server with Service Pack 6.0a. All service packs and
updates were installed in both Outlook and Windows XP.
...vba copyright protection #2
I have created a spreadsheet which utilizes many of my own custom built
macros and formulas. Does anyone know whether or not my vba code
and/or formulas can be copyrighted--ie legally protected?
Message posted from http://www.ExcelForum.com/
...2 copies of every new e-mail!
I asked my computer guru to make sure my e-mail goes to my desktop PC and my laptop. That seems to be working, but now I am getting 2 copies of every e-mail in my inbox
Can somone tell me how to turn this off so I only receive one copy of each e-mail?
On 30 Apr 2004 10:06, "Mark" <email@example.com> wrote:
>I asked my computer guru to make sure my e-mail goes to my desktop PC
>and my laptop. That seems to be working, but now I am getting 2 copies
>of every e-mail in my inbox.
>Can somone tell me how to turn this off so I only receive one...Calculating age from two date fields-Excel 2003
I'm not sure what section this question should go in.
I need to find if a person was 40 years of age or older (= or >) at his Date
of Hire. I have two columns, Birth Date and Date of Hire.
How would I write a formula to give me this answer?
Thanks in advance
A1 = DOB
B1 = DOH
That will return either TRUE or FALSE
Microsoft Excel MVP
"Veteran of the Software Cycles"
<VeteranoftheSoftwareCycles@discussions.microsoft.com> wrote in message
> I...Inventory issues in GP
The following are some of my challenges in Great Plains.
Some of the stocks received and posted into GP are not available
* Inventory enquiry for some stock is giving incorrect
* A stock item used for a kit and posted to an invoice is not
reflecting on the inventory balance for some items.
* At times no document description will be found for an item
allocated even when an item enquiry indicates Allocated.
* When stock transfer for project is posted it does not reflects
on the item enquiry.
* An item already transferred for proje...Add buttons for Center Across and Paste Formula
It would be very helpful if the Customize Toolbars funtion gave access to
buttons for Center Across and Paste Formulas so you don't have to a) traverse
through menus or drop-downs, or b) create macros and custom buttons to
accomplish these oft-used features.
I get tired of always having to create macros on each system I work on in
order to set up custom buttons that accomplish these simple tasks.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button i...If Then Statements #2
Need help. Need to turn the following into a formula within Excel.
If B19>45 then A19
If B19>=45 but <100 then B19*A20
If B19>=100 but <300 then B19*A21
I assumed that your first condition should read B19<45
> Need help. Need to turn the following into a formula within Excel.
> If B19>45 then A19
> If B19>=45 but <100 then B19*A20
> If B19>=100 but <300 then B19*A21
>...Pivot Table percentages #2
I have created a pivot table that is running off some data that looks like
this (simplified version):
Name Accept Decline
Joe 1 0
Mary 1 0
Fred 0 1
The pivot table then counts these columns to give the total number of
accepts and declines (on 2 seperate lines). Is there a way within the pivot
table to represent the declines as a percentage of the accepts?
I've tried using the % of Row and % of Column, but I can't find a way of
doing it as a percentage of a different column/row. I have...Service STORE is falling #2
Hello to All,
I need a help with the problem that is happening with our server of
exchange 5.5 and windows NT 4.0.
The problem that is happening is that suddenly the service of STORE
seeking the mistake that is happening found the following note of MS that
am enclosing, only that we already sought and we didn't get to find a
program to be accessing some of the mentioned doors.
Did this problem happen please already with you or you know what can be?
Backup and apply SP4 and post-SP hot-fixes.
Lincoln Rollin wrote:
> Hell...CRM Sales for Outlook 1.2
We are using mscrm 1.2 successfully for a while now (no
mail router, no outlook client). Now we tried to
integrate it into our exchange environment using the
outlook client. Online is working fine but the offline
functionality isn't working. Obviously the local msde-
database is not getting any data.
The error message is: "Metadata-Cache error, No entity!"
The log says:
MSCRM Platform Error Report:
Error: Exception from HRESULT: 0x80040E00.
Error Message: Exception...due dates #7
you've made my life easier
now if I could only type
canman's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14596
View this thread: http://www.excelforum.com/showthread.php?threadid=262235
You're welcome !
> now if I could only type
but why type ? <g> ..
when you could always do a copy and paste direct
from the posting to the target cell(s) / dialog box(es)
(but you would need to watch out for any line breaks
in the pasted formulas - especially l...Dynamic Charting By Dates
This is in reference to Jon Peltier's article on dyamic charts.
My question is the example given is using data that goes down a column.
Column A is the dates, Column B is the data, ect...
My data flows across rows, so all my dates are in row 1 and the data is in
I would like some help converting Mr. Peltiers technique to fit my need.
This code needs to go across a row instead of down a column.
As well as...