ExcelBanter - work sheet linking

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - work sheet linking (https://www.excelbanter.com/excel-discussion-misc-queries/127475-work-sheet-linking.html)

krishnan

work sheet linking

how to link the entire row of a work sheet to another work sheet based on
some condition. Any help

Regards
krishnan

Mike

work sheet linking

=IF(Sheet1!A1="Something I want it to be",Sheet1!A1,"")

Put this in A1 of sheet 2 and drag along the row. If the condition you set
evaluates as True then it will copy Sheet 1 A1 to Sheet 2 A1 etc.

"krishnan" wrote:

how to link the entire row of a work sheet to another work sheet based on
some condition. Any help

Regards
krishnan

All times are GMT +1. The time now is 12:31 AM.