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 sheets in the workbook and all data that is copied into these needs to go into SHEET 1 (doing it itself, not manually).
My question is when I download my data and paste into SHEET 2, how do I get it to automatically go on to the SHEET 1, taking only certain parts of the data, in this case B and F.
The attached is just a small example of the data I need from SHEET 2. On SHEET 1 There is a list of numbers on the left and more, how can I get this data to filter itself onto SHEET 1 in the right column then adding the numbers on the left together. So, on SHEET 1, 160 -T will show 7 because there is 7 1's below for that Org.
Sorry if i have made this sound long winded, I am awful at explaining. I have basic knowledge of excel but I cannot get my head around formulas.
It should look something like this.
Any advice would be great. Thanks
1 Reply
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.
