View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gumby gumby is offline
external usenet poster
 
Posts: 6
Default 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