MS Excel 2007 Macro/Formula problemSolved/Closed

Question

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 ;-))



Configuration: Windows 2003 / Firefox 3.6.6

rizvisa1 · Answer

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

cellbar · Answer

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?

cellbar · Answer

Thanks - have answered my own question and sorted it!!

Thanks again for all your help.

MS Excel 2007 Macro/Formula problem

3 responses

Similar discussions

Subscribe To Our Newsletter!