Copy and Paste to another sheet
I have a program that gets data entered on a daily basis. This
information then gets trasfered to another YTD data sheet in the work
book and put into a graph. I need a command button to copy the
information and paste it in the YTD data sheet, only I want it to
paste one cell down from the previous paste each time, so each row is
a day of data. Can someone explain how to create a macro that will
copy the data, look at the other sheet and paste it in the row below
the data that was pasted the day before?
May be a little confusing, please let me know if you need more
explanation.
Thanks for anyone's help!
|