I have a sheet called ‘Personnel’ from which I would like to take values from different columns and insert it into specific fields of the next blank row of the sheet whose name matches the value in column L of Personnel.

In the sheet named ‘Personnel’ Column L has a drop down of values corresponding to grant numbers. If the value is grant number ‘101242’, take the data in column K and insert it into the next blank row of column H of the sheet named 101242. Then also take the value of column A from the same row in ‘Personnel’ and insert it into the same row as previously into column D of the sheet ‘101242’. I would like this to occur for each value in column L of Personnel to insert the name and salary into the corresponding Expense sheet for that grant. 

​I have a sheet called ‘Personnel’ from which I would like to take values from different columns and insert it into specific fields of the next blank row of the sheet whose name matches the value in column L of Personnel. In the sheet named ‘Personnel’ Column L has a drop down of values corresponding to grant numbers. If the value is grant number ‘101242’, take the data in column K and insert it into the next blank row of column H of the sheet named 101242. Then also take the value of column A from the same row in ‘Personnel’ and insert it into the same row as previously into column D of the sheet ‘101242’. I would like this to occur for each value in column L of Personnel to insert the name and salary into the corresponding Expense sheet for that grant.   Read More

​