so i have one tab with data with all my data. i have another tab with a macro mining filtered fields. i only want 6 columns in the end of the 30 original columns to paste over. in doing so it pastes each column with running rows into millions when there should only be for example 10 rows of data per column. any ideas how to set range with values indtead of creating a million rows of blanks space?