I need to figure out how to have Excel go to another sheet in a workbook and determine if a value exist and if it does exist, then copy everything in the row to the right of the value to a specified sheet in respective columns.
1. What do you mean "exists?" Test to see if a cell is empty? Yes
And perhaps that it contains a particular thing? Looking for the letter "B" or something like that.
2. What do you mean by "the row beside it?" Just the adjacent cells to the right and left? The remaining row to the right of it with information in it or just specific cells in that row.
Or perhaps the entire row? Not necessarily
3. Do you want just the cell contents copied or do you want to include all cell properties (color fill, font, borders, validations, comments, etc.)?
Yes everything.
Anyone have any ideas? Help.
1. What do you mean "exists?" Test to see if a cell is empty? Yes
And perhaps that it contains a particular thing? Looking for the letter "B" or something like that.
2. What do you mean by "the row beside it?" Just the adjacent cells to the right and left? The remaining row to the right of it with information in it or just specific cells in that row.
Or perhaps the entire row? Not necessarily
3. Do you want just the cell contents copied or do you want to include all cell properties (color fill, font, borders, validations, comments, etc.)?
Yes everything.
Anyone have any ideas? Help.