U
ufo_pilot
I work with excel every day, but have yet to try macros.
Now I am at a point where I wish I had spent more time on this.
I need a macro (or something) that will transfer data from selected cells of
a worksheet to another worksheet in that same workbook ON A DAILY BASIS.
The first worksheet ( INPUT sheet) has data entered in column A
after calculations, it spits a number out in column B once for every 5
rows ( 30 individual numbers)
These numbers have to be captured every day, so I have worksheets named
January, February, March... etc (Monthly sheets) - read only.
The INPUT sheet has the function "=TODAY()"
At completion of the input, I have a button ready ( "Enter data") ( that's
as far as I got with this macro stuff) which can be clicked, but is of no use
as yet.
How do I get the data to "Stick"
In January-sheet cell B36 I wrote a formula =IF(B35=INPUT!E3,INPUT!C3,"")
Row35 has 1-1-06 to 1-31-06
INPUT!E3 is the =TODAY()
INPUT!C3 is one of the 30 numbers captured that needs to be saved under
January which will be displayed in a chart on that sheet
This puts the data in the correct monthly place at that particular day, but
the next day it is gone, because it relies on the DATE - which changes.
Basically I need the INPUT sheet to be able to be reused every day, without
loosing data on the monthly sheets which were transferred from previous days.
I know this sounds a lot. And I don't need it 'till next year, but I would
really like to get this done earlier, first because I need something to learn
in my spare time -during break here at work, and second it would help the
auditors in our facility save a great deal of time (this is a paper trail up
to this point and I would like to get it out of the filing cabinets and into
the computer) besides every once in a while we do studies on these (150 each
day) numbers, which need to be dug out from the files and typed into sheets
that display a monthly graph. -Guess who usually gets to volunteers for that
job every month...
I can send you a copy of the sheet if you need more information or just
e-mail me for more info
(e-mail address removed)
Thanks a whole lot in advance to all you Macro-Guru's out there
Now I am at a point where I wish I had spent more time on this.
I need a macro (or something) that will transfer data from selected cells of
a worksheet to another worksheet in that same workbook ON A DAILY BASIS.
The first worksheet ( INPUT sheet) has data entered in column A
after calculations, it spits a number out in column B once for every 5
rows ( 30 individual numbers)
These numbers have to be captured every day, so I have worksheets named
January, February, March... etc (Monthly sheets) - read only.
The INPUT sheet has the function "=TODAY()"
At completion of the input, I have a button ready ( "Enter data") ( that's
as far as I got with this macro stuff) which can be clicked, but is of no use
as yet.
How do I get the data to "Stick"
In January-sheet cell B36 I wrote a formula =IF(B35=INPUT!E3,INPUT!C3,"")
Row35 has 1-1-06 to 1-31-06
INPUT!E3 is the =TODAY()
INPUT!C3 is one of the 30 numbers captured that needs to be saved under
January which will be displayed in a chart on that sheet
This puts the data in the correct monthly place at that particular day, but
the next day it is gone, because it relies on the DATE - which changes.
Basically I need the INPUT sheet to be able to be reused every day, without
loosing data on the monthly sheets which were transferred from previous days.
I know this sounds a lot. And I don't need it 'till next year, but I would
really like to get this done earlier, first because I need something to learn
in my spare time -during break here at work, and second it would help the
auditors in our facility save a great deal of time (this is a paper trail up
to this point and I would like to get it out of the filing cabinets and into
the computer) besides every once in a while we do studies on these (150 each
day) numbers, which need to be dug out from the files and typed into sheets
that display a monthly graph. -Guess who usually gets to volunteers for that
job every month...
I can send you a copy of the sheet if you need more information or just
e-mail me for more info
(e-mail address removed)
Thanks a whole lot in advance to all you Macro-Guru's out there