Hi. I guess like many, I come to this forum having encountered an issue i can't resolve. A little background to this question:- I have only recently felt able to enter formulae and get a spreadsheet to be useful to me rather than just entering data. I (foolishly) volunteered for a role and have inherited a s/s which I have made great headway with but now have an issue and a deadline.
I have a worksheet with 8 columns each with a data filter and a "pick from drop-down menu" list and a rather annoying message if a rogue entry is made. I mention these only because it may affect an answer.
I have created another column which as yet contains no filter or data. What I would like to do is create a rule to export some (or all) of the whole row where I enter something in this new column, to another (maybe be more than 1) worksheet. The source worksheet contains over a 1000 entries and I will need to export maybe 1:40 to a destination worksheet(s). It is also the main point of data entry for the whole workbook.
Any help will be gratefully received but please assume my limited knowledge; I have spent a couple of hours Googling this and macro this that and the other has left me bewildered.
Steve
Bookmarks