MS Excel 2007 Macro/Formula problem

[Solved/Closed]
Report
Posts
3
Registration date
Tuesday July 6, 2010
Status
Member
Last seen
July 7, 2010
-
Posts
3
Registration date
Tuesday July 6, 2010
Status
Member
Last seen
July 7, 2010
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
3
Registration date
Tuesday July 6, 2010
Status
Member
Last seen
July 7, 2010

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?
Posts
3
Registration date
Tuesday July 6, 2010
Status
Member
Last seen
July 7, 2010

Thanks - have answered my own question and sorted it!!

Thanks again for all your help.