Macros for copy and pasting

Question

Hello!&nbsp;&nbsp;I am looking to be able to copy and paste information (mostly forecast data) into an excel spreadsheet and then in a new speadsheet it will add the data's month by month forecast based on the data I pasted. Any info you have about forecasting and marco's would be helpful.&nbsp;&nbsp;Thanks!&nbsp;Brit

ingeborghawighorst · Answer

Hi Brit,&nbsp;your question is very vague. Maybe you need to take a look at a few VBA tutorials. There's lots of learning resource for Excel VBA on the web. Then, when you get stuck with a specific aspect of your code, post it here and we can help.&nbsp;

deleted · Answer

I think using a macro would be a mistake, why not try excels power query. Its simple to use, no code to do exactly what you are asking it to do.&nbsp;&nbsp;

matt mickle · Answer

Ingeborg is correct. &nbsp;There are alot of online learning resources for this type of thing. &nbsp;You can search on forums or just try using Google. &nbsp;If you want an action to happen when you paste data then you need a Worksheet Change Event. &nbsp;Here is some basic knowledge about events that can get you started:&nbsp;http://www.cpearson.com/excel/events.htm

Forum Discussion

Macros for copy and pasting

Share

Resources