I have a workbook that requires a large quantity of data to be on one sheet for sorting purposes, and as a result there's a lot of side scrolling going on. In an effort to reduce the number of columns in overall width, I would like to move some of the info further to the right, but auto-populate a comment box with the text from four of the cells in each row into one of the first cells for each row. For example:
Column A contains the Customer ID Number. Column T is Customer Name, Column U is Customer Address, Column V is Customer City, and Column W is Customer State. The sheet is auto populated via macro from a master sheet, and is about 700 rows. I would like to have a macro that copies the info from Columns T,U,V, and W and pastes that respective info for each row into a comment box in Column A so that I can hover over it and see it at a glance, instead of scrolling sideways to find it when necessary.
I have been trying to figure this out myself, but I am a novice with macros and am lost. Any help would be appreciated.
Column A contains the Customer ID Number. Column T is Customer Name, Column U is Customer Address, Column V is Customer City, and Column W is Customer State. The sheet is auto populated via macro from a master sheet, and is about 700 rows. I would like to have a macro that copies the info from Columns T,U,V, and W and pastes that respective info for each row into a comment box in Column A so that I can hover over it and see it at a glance, instead of scrolling sideways to find it when necessary.
I have been trying to figure this out myself, but I am a novice with macros and am lost. Any help would be appreciated.