Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Info combined from 2 worksheets into a new worksheet | Excel Discussion (Misc queries) | |||
Transfering info from main worksheet to multiple worksheets | Excel Worksheet Functions | |||
How do I create a formula that pulls info. from many sheets within | Excel Discussion (Misc queries) | |||
input # on sheet 1, pulls all info for # from sheet 2 | Setting up and Configuration of Excel | |||
Type in Part number which pulls info from another wksheet | Excel Worksheet Functions |