Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: uby
  • Content: Threads
  • Order by date
  1. uby

    Spreadsheet too big to fit landscape, letter size paper

    Hey Everyone! I'm wondering if this is even possible. I have an Excel spreadsheet that has various columns. Too many columns to fit a landscape, letter size paper. Is it possible to get the remaining columns that do not fit on the page to go to the next available row and slap the remaining...
  2. uby

    File Exists?

    Hello! I have a workbook that looks for information in a "Source File". Within this source file there are files for each month. They are saved by month and year (mm-yy.xls). If that month does not exist, I want it to skip looking for the files and continue the procedure. Is there a way to...
  3. uby

    Insert row

    Hi Everyone! This is probably a stupid question, but here it goes anyway! I have 2 workbooks. Workbook 1 gets funded from information in Workbook 2. If Workbook 1 runs out of rows, I want it to insert a row. Does anyone know a simple way of doing that? Thanks for any help you can offer! Uby
  4. uby

    Other options other than VLookup

    Is there another option other than VLookup to get information from another workbook?
  5. uby

    A second workbook/worksheet that populates a drop down list

    Hi! I have 2 workbooks(WB1 and WB2). The second workbook has a dropdown list that has names. The user selects a name on the list and then populates the appropriate information about that name that the user selected on the lower part of that worksheet. All of this information is on the first...
  6. uby

    Populating a listbox with data from another workbook

    Hello All! Question... I would like to populate a listbox with data from another workbook without having to create a worksheet to paste the information for that listbox, in that workbook. Is this possible? Ex: Workbook 1, Sheet1 has the listbox. Workbook 2, Sheet1 has the First and...
  7. uby

    Fund an Excel worksheet from multiple external Excel workbooks

    I am trying to get certain information from multiple external Excel workbooks. There are about 5 external workbooks. Is this doable as a macro? Or do I have to use the vlookup? Thank you in advance for any help anyone can offer. Uby
  8. uby

    Inserting rows in different breakdown sections

    I have a workbook with two worksheets. The first worksheet has all the information that is going to go in the second sheet. The second sheet is broken down into groups, identified by a 3 letter code. Ex: Group 1 takes all the MCVs. Group 2 takes all the LCVs. And so on. I would like to add...

Part and Inventory Search

Back
Top