Hi,

I am having a workbook containing 12 worksheets one for each month. The
closing balance of each month is to be copied as opening balance of the
following month with values only. (Range g9: g195).I have tried to record a
macro for this task but to no avail. The data has to be copied to Range ( E9
: E195). Any gentleman in the community may give an idea to accomplish this
task? Whether this code can be used to copy any range to any range (with
values only).