Quote:
Originally Posted by Spencer101
Hi,
4000 rows of data would probably be quicker to manipulate in this way manually than it would be to write some kind of formula/VBA.
How often do you need to do this?
|
Hi, well I forgot to mention I have about 20 worksheets of the same type which all need collating into one column in each worksheet. To add, I get this about twice a month so a formula would be of great help, doing in manually is undesirable really.
Thanks