MS Excel 2007 Macro/Formula problem

Solved/Closed
cellbar Posts 3 Registration date Tuesday July 6, 2010 Status Member Last seen July 7, 2010 - Jul 6, 2010 at 10:37 AM
cellbar Posts 3 Registration date Tuesday July 6, 2010 Status Member Last seen July 7, 2010 - Jul 7, 2010 at 08:10 AM
Hello, ##Please help! I am new to this and so fed up!!

I need to transfer data from two worksheets onto another worksheet and I just cannot do it!!

I have treid the IF function but it will not take data from 2 different sheets and place it onto the new sheet (all within the same workbook).

What do I need to do if:

If a If a "W" appears in coloumn J on Sheet 1 and Sheet 2, I need all the info in relation to that row (6 columns in all which hold data) transferred to the new sheet.

Any help would be greatly appreciated ;-))



3 replies

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jul 6, 2010 at 06:55 PM
Have you tried to use filter ? You can record your action that will give you the code

All you have to do is,
start recorder
filter the sheet for W
copy the visible rows
paste on other sheet
stop the macro
1
cellbar Posts 3 Registration date Tuesday July 6, 2010 Status Member Last seen July 7, 2010
Jul 7, 2010 at 08:02 AM
Thanks so much - just brilliant! Exactly what I was looking for. How do I set up for the macro to run auntomatically or can't this be done?
0
cellbar Posts 3 Registration date Tuesday July 6, 2010 Status Member Last seen July 7, 2010
Jul 7, 2010 at 08:10 AM
Thanks - have answered my own question and sorted it!!

Thanks again for all your help.
0