Reference Dynamic Rows in "Raw Data" Tab

[Russky]

Hello!

In the "RFP Tab 1," I have column have "Column A," where each cell should reference a corresponding cell in a "Column A" in a "Raw" sheet. The Column A in the "Raw" tab will have entries added to it over time, and want the corresponding entries / rows to be automatically added to the "RFP 1" tab. Is this possible?

Also, is it possible to not only reference the value, but the formatting of corresponding cells, as there will be different formats for different values / cells (dark blue, light blue)?

Please let me know if you need clarification on this request -- thank you in advance for your help!

Best,
Russky

[crazyforexcel]

Hi,

Since this is one dimensional why have 2 sheets with the same information? Am I missing something?

[Russky]

Hi Crazyeddie,

The idea is there will be multiple sheets, each one corresponding to a different document. There will be additional columns of data for each sheet. But I want the row entries to be consistent across all the sheets, but the number of row entries will grow over time.

Thanks,
David

[crazyforexcel]

Show a mock up of what might happen and then formulas can be derived by someone here. I suggest you have expected results.

Thanks