An EXCEL table, has been underway for screening, through search and selection - visible location condition - cell - copy the way the screen after A column data can be copied, but I want to copy paste it to the table of data after another column (the same is filtered), such as A column of 1,3,5 line 1,3,5 affixed to the C column line,

CodePudding user response:

Pull the formula; If you can't use the formula, and then in removing formula, can "paste special" for "value", or use the special "macro" to do

CodePudding user response:

. This operation is very easy to get wrong, kiss