I am a noob at Excel 2010. I have created a workbook with multiple sheets.
Sheet one is the global data.
All oter sheets are subsidiary sheets.
What I want is for the row of data to be automatically transferred to a specific sheet based on the selection of a scroll down item in one of the cells of that row.
Is that within the realms of feasible in Excel 2010?
As such, for value "x" in cell H10 I want the entire row to be copied and pasted in a new row in sheet named "x", similarly sheet "y" for value "y" in cell H11 and sheet "z" for value "z" in cell H12.
Can you please help?
Thanks