View Single Post
  #9  
Old December 27th, 2010, 05:47 AM
rekhasein rekhasein is offline
Banned
 
First recorded activity by OfficeFrustration: Nov 2010
Posts: 8
Default

Quote:
Originally Posted by haritkore View Post
I have always found it much easier to just select the number of rows or columns I want to insert by highlighting them, clicking the right mouse button and selecting Insert. That’s much easier than having to change a macro each time. You can also chose Insert from the menu if you don’t want to use the right mouse button.
The worksheets where the data is copied to also contain other information from other sources, and in summary needs to vary in length to represent the amount of rows that have been entered in the "datainput" worksheet.