Dreamer
07-04-2005, 09:49 PM
Hi,
Here's my problem...
Col A is the serial no.(if any), Col B is the description, Col C is month
What I need to do is... as we want to update the info to our clients ASAP, we will normally put all new data at the bottom of the spreadwheet first(without assigning any serial no.) ..and afterwards, we will do the grouping...
For example:
col --A--B ----------C
ABC111 Soft Drinks (empty)
.........
.........
in row X, find.....
col --A--B ----------C
(empty)Soft Drinks May
After grouping, it becomes...
col A -- B---- C
ABC111 Drinks May
In other words, update the new info "May" to existing record..
Since there are over 10000 rows which need to proceed, does a marco
can help this? Thanks in advance! ^^
Here's my problem...
Col A is the serial no.(if any), Col B is the description, Col C is month
What I need to do is... as we want to update the info to our clients ASAP, we will normally put all new data at the bottom of the spreadwheet first(without assigning any serial no.) ..and afterwards, we will do the grouping...
For example:
col --A--B ----------C
ABC111 Soft Drinks (empty)
.........
.........
in row X, find.....
col --A--B ----------C
(empty)Soft Drinks May
After grouping, it becomes...
col A -- B---- C
ABC111 Drinks May
In other words, update the new info "May" to existing record..
Since there are over 10000 rows which need to proceed, does a marco
can help this? Thanks in advance! ^^