Forum Discussion
i need the data from all the sheets in the workbook to link to one data sheet.
A colleague of mine made a data spreadsheet (lets call it SHEET 1), he no longer works for the company and over time the worksheet has been amended, so doesn't work like it should. There are several ...
For now, it's not Excel ability that you need to bring to bear. It's plain old descriptive English. As you acknowledge, you've not been very effective in your explanation, and that is where we need to focus first. The two images you did include--they're only images, not attached files--don't totally make sense or correspond to your attempted description.
For example,
- you refer to wanting to get "only certain parts of the data [from Sheet 2], in this case B and F. There is no column F (assuming you're referring to columns) in the first image.
- And although it's reasonable to assume that if we could see all of column A in that first image, we'd see "160 - T" in some of those cells, that and nothing more.
- and frankly, saying there should be a "7 because there is 7 1's below for that Org" doesn't make sense if you're trying to copy the data over. That's a summary of something or other....
Unless the data in this workbook is confidential, you could help us by dragging and dropping the actual workbook into your next reply. If that's not possible, then see if you can provide a more complete description.