I have posted this message before and received one reply which was asking for more detail I have included that detail but I have yet to get an answer.
Can anyone help?
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 in the same workbook.
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.
Can anyone help?
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 in the same workbook.
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.