NeVeR Posted July 13, 2010 Report Share Posted July 13, 2010 Hi all. I'm trying to make a Macro that copies information from 4 different Excel sheets and then pastes it into a notepad file. I've it working on 1 spread sheet. But it's getting the other 3 to work as well is the problem. This infomation/spread sheet will change in name and info each day. I hope you know that i mean. This is a daily task under taken by a member of staff each day and each spread sheet is save under a new name each day (4 each day) Is something like this possible where it will open 4 spread sheets ?. Or would something like a key press on each spread sheet to activate work better ?.. Like you get a prompt saying "Open SS 1 and press Enter" once copied you get another saying " Open SS2 and press Enter" and so on.. Once the 4th is done you get your Notepad open with the info. Sorry if this sounds all over the place. Also how to I get Macro Express to start a new mail in Microsoft Express... The comand in Microsoft Express is CRTL+N but anytime i try it Macro express it opens a note .. which is the short cut CRTL+SHIFT+N but i'm not pressing that. Any help would be great. thanks. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.