Hi All,
Was wondering if anyone could help. I have a spreadhsheet with about
200 entries on a worksheet called 'data' that would be updated daily.
In the first 4 columns each row has a '1', '2', 'REF', 'NV' or it is
blank.
How would i get each row with '1','2','REF'or 'NV' in the first 4
columns to be transferred to a seperate sheet(ie Sheet1, Sheet2,
SheetREF, SheetNV) and have the entries with nothing in the first 5
columns not get copied. I also need the entries that are copied to stay
in the data worksheet. This 'data' worksheet would be updated every day
and i would need to transfer the data across to the corresponding
sheets every day when a button is clicked on
I have tried everything in my limited excel arsenal with no
luck(extremely frustrating!), if anyone could help that would be
brilliant!
I have attached a picture of how the data sheet would look(simplified)
+-------------------------------------------------------------------+
|Filename: sheet.JPG |
|Download:
http://www.excelforum.com/attachment.php?postid=4061 |
+-------------------------------------------------------------------+
--
Steel Monkey
------------------------------------------------------------------------
Steel Monkey's Profile:
http://www.excelforum.com/member.php...o&userid=29051
View this thread:
http://www.excelforum.com/showthread...hreadid=487819