S
sq246
Is it possible to run a macro through an IF function and, if so, how do I do
it?
My scenario is as follows:
On my spreadsheet I have constantly updating values in columns C,D and E.
Column A represents the time (increasing in 1 minute increments from 9.30am
in cell A3 to 4.00pm in cell A393) and columns C,D and E will display the
values at that particular time, otherwise they display 0. In other words at
9.30am the values will be displayed in cells C3, D3, and E3 and all other
cells in those columns will read 0, at 9.31, the only cells displaying value
other than 0 will be C4,D4 and E4.
What I need to do is to find a way of recording the values in each cell
before they revert to zero - to do this i was thinking of running a macro
which would copy and paste special the value of any cell (from column C to
column G, column D to column H, column E to column I) which had a value of
greater than 0.
What should happen is that by 4.00pm all cells in range C3 to E393 would
have been copied and pasted special value only to range G3 to I393, at a rate
of one row per minute. As this is happening during the course of each day,
the data in columns G,H and I would be being used to generate 3 charts, 1 for
each column.
Any suggestions?
it?
My scenario is as follows:
On my spreadsheet I have constantly updating values in columns C,D and E.
Column A represents the time (increasing in 1 minute increments from 9.30am
in cell A3 to 4.00pm in cell A393) and columns C,D and E will display the
values at that particular time, otherwise they display 0. In other words at
9.30am the values will be displayed in cells C3, D3, and E3 and all other
cells in those columns will read 0, at 9.31, the only cells displaying value
other than 0 will be C4,D4 and E4.
What I need to do is to find a way of recording the values in each cell
before they revert to zero - to do this i was thinking of running a macro
which would copy and paste special the value of any cell (from column C to
column G, column D to column H, column E to column I) which had a value of
greater than 0.
What should happen is that by 4.00pm all cells in range C3 to E393 would
have been copied and pasted special value only to range G3 to I393, at a rate
of one row per minute. As this is happening during the course of each day,
the data in columns G,H and I would be being used to generate 3 charts, 1 for
each column.
Any suggestions?