bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
https://skydrive.live.com/?cid=592f6aee22d904f4&sc=documents&Bsrc=EMSHYH&Bpub=SN.Notifications&id=592F6AEE22D904F4%21102
^posted sample workbook.
Hello
I require some assistance for a macro that will simply move data from one worksheet to "G.S Report" worksheet. with cell link in the cell
I receive montly files (August Raw data, September Raw data...December Raw data), which I simply copy paste into the raw data file (copy/paste).
would like:
-a macro once data is copied into the i.e. August Raw data worksheet (I have left AUgust and September populated in the sample), so simply paste or dump their data onto the G.S Report worksheet with links to the Raw data sheet.
-I have provided an example for the month of June and july. for august see row 1446.
so basically, I would liek each month's data to be dropped right below one another and on the last cell of each month in the G.S. Report, make a border line to show month end (see example 1445) in G.S Report worksheet
Can someone pls help!
I'm very new with macros so I would be gratefull for this help!
On row 1446 in the G.S report worksheet I have provided one example i.e. row and metrics i want to be carried over from "August Raw data" sheet.
thx u so much!
*run macro "unprotect" to unprotect sheet
^posted sample workbook.
Hello
I require some assistance for a macro that will simply move data from one worksheet to "G.S Report" worksheet. with cell link in the cell
I receive montly files (August Raw data, September Raw data...December Raw data), which I simply copy paste into the raw data file (copy/paste).
would like:
-a macro once data is copied into the i.e. August Raw data worksheet (I have left AUgust and September populated in the sample), so simply paste or dump their data onto the G.S Report worksheet with links to the Raw data sheet.
-I have provided an example for the month of June and july. for august see row 1446.
so basically, I would liek each month's data to be dropped right below one another and on the last cell of each month in the G.S. Report, make a border line to show month end (see example 1445) in G.S Report worksheet
Can someone pls help!
I'm very new with macros so I would be gratefull for this help!
On row 1446 in the G.S report worksheet I have provided one example i.e. row and metrics i want to be carried over from "August Raw data" sheet.
thx u so much!
*run macro "unprotect" to unprotect sheet
Last edited:
