wham
06-13-2006, 04:27 PM
Hi there - was a bit tongue tied with the thread title so I hope it adequately describes my problem. I'm basic to medium knowledge on excel, and have only dabbled in macros before and I am presuming it's a pretty complex one i need to solve my problem, although I am happy to be told otherwise!
I've been tasked with redoing a revenue report at work, and in my head I've conjured up what could potentially be a huge time saving way of doing things in the future as I'll be using and updating this workbook on a daily basis, although have searched help files and looked around online and can't find the formula/macro (if it exists) to enable me to do this.
The problem is this:
Sheet 1 of the workbook is a large input sheet. Every row contained in that sheet will, in column A, be titled 'red', 'yellow' or 'green' (the title is irrelevant really, they could just as easily be titled 1, 2 or 3). Columns B onwards contain other data which (at the moment) is irrelevant to the problem.
Now what I want excel to do after I've put the raw data into the input sheet (sheet 1), is to read the text in column A for each row, then automatically copy ALL data in that row over to the next empty row on another worksheet.
ie Sheet 2 will have all rows that have 'Red' in column A on the input sheet, Sheet 3 will have all those titled 'Yellow' and Sheet 4 will have all those titled 'Red'.
Is this something that is possible?
I know I can use a filter on the input sheet to just show the data I want, but each colour labelled row will contain different data to other colours, and if there is a formula/macro setup i can use to do the above, then I can set the subsequent worksheets up to hide the superflous columns from the input sheet.
Hope that makes sense, and hope one of you guys is able to help.
Thanks
Wayne
I've been tasked with redoing a revenue report at work, and in my head I've conjured up what could potentially be a huge time saving way of doing things in the future as I'll be using and updating this workbook on a daily basis, although have searched help files and looked around online and can't find the formula/macro (if it exists) to enable me to do this.
The problem is this:
Sheet 1 of the workbook is a large input sheet. Every row contained in that sheet will, in column A, be titled 'red', 'yellow' or 'green' (the title is irrelevant really, they could just as easily be titled 1, 2 or 3). Columns B onwards contain other data which (at the moment) is irrelevant to the problem.
Now what I want excel to do after I've put the raw data into the input sheet (sheet 1), is to read the text in column A for each row, then automatically copy ALL data in that row over to the next empty row on another worksheet.
ie Sheet 2 will have all rows that have 'Red' in column A on the input sheet, Sheet 3 will have all those titled 'Yellow' and Sheet 4 will have all those titled 'Red'.
Is this something that is possible?
I know I can use a filter on the input sheet to just show the data I want, but each colour labelled row will contain different data to other colours, and if there is a formula/macro setup i can use to do the above, then I can set the subsequent worksheets up to hide the superflous columns from the input sheet.
Hope that makes sense, and hope one of you guys is able to help.
Thanks
Wayne