Adding columns from different sheets to the Report

Vuckecucke

I have a Report that i have been using for some time, and I add and remove columns from the source sheet with the formula and color-coded status. I would like to include the column from a different sheet, also with formula and color-coded status.

All it does it pasts the collum and the title but no cell context (column type: symbols). i looked up the trouble shooting recommendations but so far nothing has worked.

Any ideas?

thanks!

Kerry St. Thomas

If I'm understanding what you're asking, your solution might be a cross-sheet reference and not a report.

In SQL parlance, a Report is a UNION. An entire row on Sheet A, followed by another entire row from Sheet B, etc. (Think about it as two or more sheets stacked vertically.) What you're asking about - again in SQL parlance - is a JOIN. For example, stuff on Sheet A (like social security number) is also on Sheet B, so you need to pull the stuff from Sheet B onto the same ROW as what's on Sheet A.

Once you have the data on one sheet, you can use a Report to filter and customize which columns are visible. Good luck!

Vuckecucke

yes, correct a cross-sheet reference. Funny, i kind of assumed that is the case, so i have lined up the entries to match from both sheets horizontally.

so list of names should be the same from sheet A, and Sheet B, so that the columns filtered can match the either sheet row. i even used ruler to compare one by one, and still it is not working.

Based on your comment: I added the column of interest to Sheet A. Once i don't need it on the report i will remove that column from the source sheet. i know that over 30k source sheets can be referenced per one report.

thanks for the reply!

Kerry St. Thomas

If I'm understanding what you're asking, your solution might be a cross-sheet reference and not a report.

In SQL parlance, a Report is a UNION. An entire row on Sheet A, followed by another entire row from Sheet B, etc. (Think about it as two or more sheets stacked vertically.) What you're asking about - again in SQL parlance - is a JOIN. For example, stuff on Sheet A (like social security number) is also on Sheet B, so you need to pull the stuff from Sheet B onto the same ROW as what's on Sheet A.

Once you have the data on one sheet, you can use a Report to filter and customize which columns are visible. Good luck!

Vuckecucke

yes, correct a cross-sheet reference. Funny, i kind of assumed that is the case, so i have lined up the entries to match from both sheets horizontally.

so list of names should be the same from sheet A, and Sheet B, so that the columns filtered can match the either sheet row. i even used ruler to compare one by one, and still it is not working.

Based on your comment: I added the column of interest to Sheet A. Once i don't need it on the report i will remove that column from the source sheet. i know that over 30k source sheets can be referenced per one report.

thanks for the reply!