Search results for query: *

Thank you for responding PHV. I will try this. Uby

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...

That would be nice, right? But unfortunately, I am working with pre-existing workbook, source files, etc. This is what this company has been working with for years. I am trying to automate it with what they have already. The user is internal, not that it makes a difference or anything. I...

No. The worksheet does not have that much data. I want for it to reach the total. Once it reaches the total and it still has information to paste, then move the total down by inserting a row before the total.

Thanks so much for your help!

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...

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

Awsome! Thanks so much! I will try that! Thanks again! Uby

Hey Geoff! Thanks for answering! I have a listbox and a drop down. The list box contains the fund names and the drop down contains the month of process. When the user selects a fund name and a month of process, the pretaining information comes from another workbook with the data in it. This...

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

Sorry Tony! Here is the code as it stands now! 'Open workbook1 Workbooks.Open Filename:="C:\workbook1.xls", _ UpdateLinks:=0 'Pull the fund names from workbook1 Do Until Cells(intFundName, 3).Value = "Totals" intFundName = intFundName + 1 Loop 'To not include the word...

Tony, No problem! The bottom part means.... This is a template that requires some data from the first workbook that is funded by the user manually. I have populated it by getting the information from the first workbook, copy it into a worksheet in the second workbook and the list box looks...

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...

THANK YOU SOOOOOOOOOOOOOO MUCH! That works nicely! Thanks again! Uby

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...

I have never worked with Pivot Tables. I am creating it, so I don't have to worry about the procedure to use. How would I create a Pivot Table from all the source files? Is this very time consuming? It seems that the Pivot Table is the way to go. Uby

Well basically.... I have quarterly statements that must be produced. There are 4 quarters and there are 4 files for each quarter. Under the quarters are the several fund names and the director's names that have investments in each of those funds. At the end I would like to create a separate...

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

Hey Ken! Unfortunately, the ids consist from 1 digit to 5 digits. Is there some type of function that I can do in order to insert and to get the grand total?

Ok.... The first sheet is a list of funds. For Ex: IDs Fund Name Shares Ratio So on & so on 50 cols MVABC ABC Fund ITDEF DEF Fund AVGHI GHI Fund They are all listed in alphabetical order in the first sheet. There are formulas for the totals on this page. Then... 2nd...