Macro for copying data onto another sheet

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have a workbook that contains 8 sheets of different states. These sheets have data of five differenct products' sales and achievements figures upto october 2011. now from november 2011 instead of going into individual sheets and typing data there, i have created a sheet "source". now at first column i typed names of states, then the corrosponding values of actual sales of each state then sheet name (where the value should go) and cell name (where the value should be pasted).
state name nov_actual_sales to-sheetname to-cell


how to do it with a macro?

in a nutshell i want to copy the data of a cell based on the sheet name and cell address given adjcent to it.

please help






1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
post a small extract of "source" sheet with random data and explain what you want. thank you.