MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Would it be possible to do this...?


Posted by Robert on February 05, 2002 12:28 PM

Hi, I'm a bit stuck in Excel right now, not sure what to do next. A co-worker of mine made a spreadsheet for listing new valves as they come into inventory. He made drop down lists in each category for describing each valve (Type, Size, Brand, and Quantity)
with each drop down containing every description available (such as 1" or 2" for size, Gate or Butterfly for Type, etc). What he would like to do is speed up the data entry process, so that every time a description is selected from a drop down list, it will be copied below it on the spreadsheet, and the next time to the cell below that, and so on. He asked me if I could figure out how to do this, and I thought perhaps a macro could be created, however my VB is very rusty, and I was wondering if, and how this could be done? Any help would be greatly appreciated!


Posted by Juan Pablo G. on February 05, 2002 12:59 PM

To copy A3 to next empty row in Sheet2 use this code

Range("A3").Copy Sheets("Sheet2").Range("A65536").End(xlUp).Offset(1)

Juan Pablo G.

Posted by Aladin Akyurek on February 05, 2002 1:10 PM

Hello,

Do you know of any other options to bring in a PDF file besides the text import wizard?

Woody

Posted by Juan Pablo G. on February 05, 2002 1:17 PM

Aladin, Repost please ? [NT]

Posted by Aladin Akyurek on February 05, 2002 1:52 PM

Re: Aladin, Repost please ? [NT]

I was wondering whether the procudure you describe here cannot be adapted to the question Larocque posed a few days ago:

19146.html

What do you think?

Aladin

=============

Posted by Juan Pablo G. on February 05, 2002 3:00 PM

Re: Aladin, Repost please ? [NT]

I think so. I'm answering to it now.

Juan Pablo G.