Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro preparing numbers to be booked (columns to be chosen conditionally)
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lots of numbers and columns | Excel Discussion (Misc queries) | |||
macro to eliminate repeating account numbers | New Users to Excel | |||
How to sort random numbers in columns | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) |