Search results for query: *

Thank you Tony and Bob for all of your help. I finally got it to work. I had a couple typos on the worksheet names, but it works beautifully now. Thanks again! :)

That didn't work. When it errors out: SheetOrder(I) - "Two Months Originations" SheetOrder(LBound(SheetOrder))="Review Findings - CA use ONLY" LBound(SheetOrder) = 0 Sub MergeSheets() 'Variable defines Dim currbook As Workbook Dim currsheet As Worksheet Dim s As Worksheet...

Tony, Yes I did replace with my own names. Are the names case sensitive?

Thanks guys! I tried both of your suggestions and neither one worked. Maybe I missed something. Tony, yours errors out at this statement Sheets(SheetOrder(i)).Move After:=Sheets(SheetOrder(LBound(SheetOrder))) Subscript out of range error 9. Bob, yours runs through and says it is complete...

Thanks for the responses guys. To add to what I said before, I don't want the sheets in alpha order. I have an order that I would like the sheets in, but it's not alpha or number. Is there a way to store the names of the sheets in an array and then put them in the order based on another...

I have a workbook with 9 worksheets that are populated based on other workbooks. I also need to add other worksheets to this workbook from other workbooks. After all the worksheets are in the one workbook, I would like to put them in a specific order based on the sheet name. I have the code...

Do you mean when I'm assigning values from one worksheet to the other? I tried to distinguish this but I get an error. any suggestions?

It look like it should work, but when I run it, it doesn't delete the first row. It just adds the new data into row 16. It's like it's ignoring this section of code. I'm stumped???????

Thanks, Skip! I tried your code and it didn't work. It's like that section of code is just being ignored. Not sure why. The purpose of the macro is to populate a table in an excel sheet. since there are only 4 rows in the table, it should delete the old data and add the new data to the last...

I am populating a table in Excel with data from other worksheets. The table has four rows. when the rows are filled it should delete the first row moving everything up one row and adding the new data to the last row. Here's the code I have to do this, but it isn't working. NextRow =...

That worked great! Thanks guys!!

I wrote a program to copy info from excel and put it into a word document. The only problem I'm having is keeping the formatting of the numbers. I have the code format the cells in excel and I have the text form fields in word formatted correctly, but when the numbers are transferred, the...

Ok, I must not be searching for the right keywords because I can't find what I'm looking for. Can you help me out? Sorry, I'm new to all of this. Thanks in advance.

Hi! I'm working with a password protected Access Database trying to export certain data from a query to specific cells in a preformatted Excel spreadsheet. I have a form in Access that I would like to add a button to to do this. Is this possible? Any help is greatly appreciated!