Hello,

I would like to ask you once again for your help, this time with the
following macro problem:

1) From each sheet within the workbook I would like to copy rows 7 to 50
- from column B and
- from column where the value in row 6 equals the value in cell A1 (can be
different from one sheet to another).

(to be more precise,
- in column B i have the account numbers
- in columns 'I' to 'xx' i have the amounts to be booked for the
month
- the months specified in row 6 (headers) may vary from time to time
(they are dynamic)
- in A1 i input the current month and than I would like to tell the
macro to find the column for this month)

2) Paste them into a newly created sheet, one under another:
- rows B7:B50 to column A
- rows xx7:xx50 to column B

3) Delete the rows where the value in column B equals either 0 or " ".

Do you have any hints for me how to convert this steps into the VBA?
Many thanks for your suggestions!

Mark