Procedure for "Pasting to the next empty cell"
Posted by Larry H on November 21, 2000 8:12 AM
I have 2 XL worksheets that I use for Equipment Quotations. The "Catalog" sheet consists of descriptions of various equipment components and pricing information. These descriptions fill several rows and columns for each item
To create a quote, I copy all of the cells for the selected item, select the 2nd XL worksheet named "Newquote", and paste the copied cells to the new quote. If the quotation includes multiple items (it usually does) I then go back to my "Catalog", scroll down thru the various items until I find the next item to include in the new quote. I then repeat the process until I have copied and pasted all of the components that are to be quoted. This process takes me 10 to 15 minutes per quote. Everyone else requires twice the time and they frequently screw it up. While the process seems simple to me (I created it) it's too complex for some of my associates to comprehend.
My desire is to create an automatic version of the cut and paste process. By creating a cut and paste macro for each item, my associates could simply scroll through a list of item descriptions and click on the "Select" button that I can assign to each macro.
My problem is this...I can't find a way to automatically paste the selected item to the new quote. I need to paste each selection to the next unused cell in column A following the previously pasted item.