Is there a way to achieve the first method using VBA, without having to use PasteSpecial? But when filter is applied, only one corresponding is fetched from Column C. In this case, I am prompted with a message that warns: "Merging cells keeps the upper-left value and discards other values". The second method: I use the Merge Cells from Home Ribbon. Also, notice that when the cells are unmerged, all underlying cells still have the data in them. When I use this method, I can apply filter in Column A (ISD Code), and it fetches all corresponding rows from Column C (State). The first method: I am merging cells using format painter by copying format of another set of merged cells from Column B to Column A. The need: I want to merge some cells with same data in a column so it looks more organized, at the same time I should be able to apply a filter on that column that can fetch all rows from other columns corresponding to merged cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |