Greetings, new here and also a newbie to excel but learning my way around. Little background on my excel file (workbook): as of now it consists of 12 sheets all of which are identical for each month and we input information daily tallying certain criteria. There is also a year to date sheet that houses even more information based on the year. We also utilize around 15 different people so some information is based on their names when placed in a cell.
Based on that info I am trying to gather certain info during the month and have it placed on another sheet or have it placed in another excel file.
Example: let's say column F, when a designated "text" is input, I am wanting the information in cell1,cell2,cell14 and cell 15 of that adjacent row to be pasted into another worksheet or excel file. I am not looking to move all the information in the row since we have a ton of it but only looking to copy 4 cells.
I am lost on how to do this or if it's even possible, macros, vbas? Or anything.
Thank you for reading.
Based on that info I am trying to gather certain info during the month and have it placed on another sheet or have it placed in another excel file.
Example: let's say column F, when a designated "text" is input, I am wanting the information in cell1,cell2,cell14 and cell 15 of that adjacent row to be pasted into another worksheet or excel file. I am not looking to move all the information in the row since we have a ton of it but only looking to copy 4 cells.
I am lost on how to do this or if it's even possible, macros, vbas? Or anything.
Thank you for reading.