Hey everyone! First time forum user here! Anyway I am a very unskilled VBA user since I only had to do it for 1 class in college (which was years ago!). Anyway, I want to create 1 page called SuggestionSystem (Excel 2010) and have cells that people will fill in with production suggestions. I want a button on that page that when pushed all the data in SuggestionSystem cells will be stored in an un-opened page called SuggestionData. Would it be possible for someone to give me the entire code (with 'explanations) so that I could just copy and paste it? The cells with data on SuggestionSystem will be merged cells: F4:G4, L4:M4, R4:S4, F9:G9, P9:Q9, H14:O29. I would like these data points stored in 1 row in the new sheet with a +1 code that keeps them stored in order (one after another). I REALLY could use some help guys! thanks!!!
Bookmarks