Subject edited by HansV to make it more descriptive than just 'Excel'.
Novis in VB needs help!
Within an excel spreadsheet, I need a code to undertake the following task.
From Wookbook A, I want to filter on a particular column (non blanks). From the list greated, I then want to copy and paste specific data (Eg from differently headed columns) into a new Workbook ([img]/forums/images/smilies/cool.gif[/img]. I need to be able to run this macro as and when required, but subsequent paste's into Wookbook B needs to be on the next unused row.
Alternatively, when a date is entered on a particular col in Wookbook A, a code that would automatically transfer selected data to Wookbook B without the neeed for a macro button.