date macro

[MikeKBRdallas]

HI!
Thanks in advance for helping. I would like to run a
macro on a user form to take the date of report and see
if the date is on or past the 26th and send the report to
the its designated worksheet. looped.
example: IF the report is anywhere created from 26th of
the previous month to 25th of current month to go in to
spreedsheet of that current month and continue on till
project is finished. starting with the first day of
contract to be awarded. the problem is i have to use
thier form on excel. the thing is, the report will only
have a "todays date" and the data to follow in a range of
cells. No date will be written on here to show the start
date of contract. can we write one using only the current
date in reprt? Since i wont know when the contract starts
til the last minute. Is a macro possible? I do know that
the contract will be 540 days long.
I would liek a workbook with the job name and then
worksheets that are the months during the 540 days of
contract duration. one will be a form and the others
would be months to be filled with respective dialy reports
I hope i explained it easily. thanks! what macro should i
run for this.? and how do i transfer your idea to my
excel that i am creating?
mike

 

[steve smallman]

Mike,

Depending on the form that you receive, depnds on the
answer. I can't give you a tailored answer here and now.

But what I suggest to you is that you don't start
splitting the data up. What I would do with my limited
knowledge of your needs, is to import the daily report
using code to a table (one table in one worksheet), this
simplifies your importing and combining of data
dramatically.

The other advantage of this is that you can then develop
and manipulate the whole data set together. I assume the
reason for separation of data on 26th is for EOM
reporting. If you really need to do this on separate
worksheets, then write a separate routine to extract a
month and save it appropriately. However, I would be more
inclined to identify each date with a year/reporting
month at the time of import, and then prepare my monthly
report by using filters and possibly subtotals (gives you
each month to date and possibly FY to date and project to
date).

Steve