I want Sheet 1 data in a column to show on Sheet 2 when added
I want to add projects listing the project name, location, and status in Sheet 1 and when they are added there, I want them to populate automatically on sheet 2 in the same project name, location, and status columns.
-- A report will not work because there is additional column data in sheet 1 and sheet 2.
-- I tried a number of different index function formulas but none were working for me. And if I drag the formula down in each column of Sheet 2, will it update the correct row #?
-- Work around with cell linking, but it's only allowing me to link up to 20 rows. I think this is an option, but there is a better one.
Help? @Paul Newcome
Help Article Resources
Check out the Formula Handbook template!