One may want to transfer rows of specific columns to another file based on the date mentioned in one column. Transfer rows which pertain to a specific year into the respective worksheet of another file. For transferring rows of data from only one worksheet of the source workbook, please refer to files in this zipped […]
Read More →
{ 0 Comments }
A range of cells has multiple background colours. Depending upon the colour selected by an end user via a cell drop down, those cells (along with information in other columns) should get transferred to another worksheet. You may refer to my solution in this workbook.
Read More →
{ 2 Comments }
When running the Goal seek functionality, one can specify on one “Set cell”. To Goal seek on multiple cells, refer to the this workbook.
Read More →
Transfer specific columns to another workbook based on conditions
{ 0 Comments }