VAB to copy cell values into new Sheet, Overwrite if needed and based off of Cell Value in a column
I have two sheets. Sheet1 and Sheet2
On sheet1 I have some finaical numbers that run. For instance I want
to run a particulay day of data and it returns certain values. I would
like to be able to click a command button and have the data copied to
sheet2 into certain cells in a column based of the day of the week.
For instance if B2 on Sheet 1 Equals Monday I want it to find the
column on sheet2 that has Monday in it and copy certain cells from
sheet1 into certain cells in sheet two under that column.
Thanks,
David
|