i have one excel sheet Name Is “Unfilter”. in that columns (Name,Dept,City,Contact).
i want to copy of “Unfilter” columns (Name, City) to another sheet name like “Filter”.
i want copy and paste only (Name and City)
how can do it ?
read your sheet into a datatable
delete the columns you dont want from that datatable
write the datatable in the new sheet