Build a Worksheet that pulls info from other Worksheets
We currently have a spreadsheet that pulls information out of the cells of
other worksheets. VBA was not used to build this spreadsheet and the creator has long since left the company. The spreadsheet broke and we can't figure out how to fix it, so I would like to rebuild it using VBA. I'm a little rusty and was wondering if someone could walk me through this or point me to a HOW TO. Thanks! |
Build a Worksheet that pulls info from other Worksheets
You pobably have a corrupted workbook. The way I fixed bad workbooks is copy
each sheet of the workbook to a new workbook. 1) OPen new workbook and old workbook 2) right click on tabs on botttom of old workbbok (normally sheet 1) and click move or copy. Then copy to new workbook. "HeatherLou1974" wrote: We currently have a spreadsheet that pulls information out of the cells of other worksheets. VBA was not used to build this spreadsheet and the creator has long since left the company. The spreadsheet broke and we can't figure out how to fix it, so I would like to rebuild it using VBA. I'm a little rusty and was wondering if someone could walk me through this or point me to a HOW TO. Thanks! |
Build a Worksheet that pulls info from other Worksheets
Joel-
Thanks for the tip - and I will try that in the future - but, when I right click on the different workbook tabs, the copy option was greyed out. I tried to actually copy the worksheet and paste it into a new workbook. Here's what happened: The password box came up (because all of the workbooks are password protected) for the first two files. I entered the password and the next file name came up. When the third one came up, it asked for the location of the file. I pointed to the right file, but then the program was unable to find ANY of the cells I need it to pull. I *know* that those cells are in there so I have no idea why it is freaking out. This is why I just want to build this thing in VBA. It's harder to break that way. Thanks! "Joel" wrote: You pobably have a corrupted workbook. The way I fixed bad workbooks is copy each sheet of the workbook to a new workbook. 1) OPen new workbook and old workbook 2) right click on tabs on botttom of old workbbok (normally sheet 1) and click move or copy. Then copy to new workbook. "HeatherLou1974" wrote: We currently have a spreadsheet that pulls information out of the cells of other worksheets. VBA was not used to build this spreadsheet and the creator has long since left the company. The spreadsheet broke and we can't figure out how to fix it, so I would like to rebuild it using VBA. I'm a little rusty and was wondering if someone could walk me through this or point me to a HOW TO. Thanks! |
All times are GMT +1. The time now is 01:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com