Page 1 of 1

[Solved] Second sheet to be update based on first sheet.

PostPosted: Wed Dec 04, 2019 11:16 am
by sainudeen
Dear all
I have a spread sheet contains 2sheet one for summary and another is plan sheet. plan sheet has to be update automatically ones the summary sheet change the status like below .

1) Ones i am changing the STATUS AS "Pulling' in Summary sheet then the line information has to go to planning sheet with relevant information (see the sample Plan sheet ).

2) each time i am changing the line status as "pulling" in Summary sheet then it has to go to planning sheet below the existing data with out duplication .

Many thanks in advance for any assistance you could offer

Re: Second sheet to be update based on first sheet.

PostPosted: Wed Dec 04, 2019 7:40 pm
by MrProgrammer
sainudeen wrote:1) [Once] i am changing the STATUS AS "Pulling' in Summary sheet then the line information has to go to planning sheet with relevant information (see the sample Plan sheet ).
2) each time i am changing the line status as "pulling" in Summary sheet then it has to go to planning sheet below the existing data with out duplication .
What you have just described is a "filter", which is most easily accompished with Data → Filter → Standard/Advanced → {Select criteria} → More options → Copy results to → {your planning sheet}. If you want the filter to update automatically, study [Tutorial] Sorting and Filtering data with formulas, which has examples of what you want.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.