Forum Discussion
Link certain data from one tab to another based on condition
The structure shown in your picture makes no conceptual change to my prior reply, but details change.
Change the value in cell B3 on the Cursanti worksheet in the new attached workbook to see the results. (And be sure to read the final note on the _Info worksheet.)
From your picture it appears that you are using Google Sheets rather than Microsoft Excel. No guarantee is given that the partial solution will work with Google Sheets also.
A formula cannot put the data elsewhere; you would need VBA or Office Script to perform that. But a partial solution using a formula is possible. See the attached workbook.
SnowMan55 Thank you.
I will try to be more specific and I have attached a picture of my spreadsheet. Basically if in column A on the main sheet it is selected Hot or Warm the same information for all the columns to be transferred for that lead in the next tab (from Status to the one called Cursanti). So, for example maybe the information for person from row 5 on the main one (Status) to be copied to the second tab (Cursanti) in the 2nd row. And than perhaps the next person could be in row 13 and needs to be copied in the next empty row, row 2 on the next tab.
The structure shown in your picture makes no conceptual change to my prior reply, but details change.
Change the value in cell B3 on the Cursanti worksheet in the new attached workbook to see the results. (And be sure to read the final note on the _Info worksheet.)
From your picture it appears that you are using Google Sheets rather than Microsoft Excel. No guarantee is given that the partial solution will work with Google Sheets also.- Thank you.
