Copying data from one worksheet to another
Solved/Closed
rencharles
Posts
1
Registration date
Saturday August 9, 2008
Status
Member
Last seen
August 10, 2008
-
Aug 10, 2008 at 12:29 PM
TopherPUSA - Aug 25, 2010 at 02:50 PM
TopherPUSA - Aug 25, 2010 at 02:50 PM
Related:
- Copying data from one worksheet to another
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- How do you add a username or author to a worksheet - Guide
- How to be offline in whatsapp when data is on - Guide
- Display two columns in data validation list but return only one - Guide
1 response
If I were you, I would experiment with the powers of "SORTING DATA" This can allow you sort all the date of one column into different types of order.
This way, you can zero in on columns that pertain data.
I use it all the time and it's great.
In 2007, go to "Sort and Filter" Select Custom sort and input the rules you wish to apply.
Let's say, Sort column C, in ascending oder. All irrelevant rows will be sent to the bottom and your Meat, so to speak, will be at the top. Use the isolation of these rows to write formulas on another sheet, or different column. (the formula's should stick if you re-sort the rows according to values of different columns)
Play around with it, and I'm sure you could find a solution there.
This way, you can zero in on columns that pertain data.
I use it all the time and it's great.
In 2007, go to "Sort and Filter" Select Custom sort and input the rules you wish to apply.
Let's say, Sort column C, in ascending oder. All irrelevant rows will be sent to the bottom and your Meat, so to speak, will be at the top. Use the isolation of these rows to write formulas on another sheet, or different column. (the formula's should stick if you re-sort the rows according to values of different columns)
Play around with it, and I'm sure you could find a solution there.
