Excel Planet
New Member
- Joined
- Nov 16, 2017
- Messages
- 26
Hi there!!
I increasingly finding it difficult to adjust a huge data set which was deveoped for business plannig purposes. Changing non-adjacent rows require filtering the entire data set. This in turn implies that you just can't paste the new data over filtered data set in excel. I know I could have made a workaround by inserting a new column and filter the data accordingly. However, I'm assuming there is far a better solution to make this work in a faster way.
I increasingly finding it difficult to adjust a huge data set which was deveoped for business plannig purposes. Changing non-adjacent rows require filtering the entire data set. This in turn implies that you just can't paste the new data over filtered data set in excel. I know I could have made a workaround by inserting a new column and filter the data accordingly. However, I'm assuming there is far a better solution to make this work in a faster way.