S
SiH23
I would be so grateful if someone could help me to automate this process.
Cells Y2 to BK2 - alternate cells within this range contain monetary values.
Cells Z2 to BL2 - alternate cells within this range contain cheque serial
numbers.
I need a macro to do the following:
If the monetary value in £'s sterling in cell V2 is greater than £350.00, to
count the number of monetary values in alternate cells between Y2 to BK2. For
example: cell Y2, cell AA2, cell AC2, cell AE2 etc, etc. Add the same number
of rows as the number of monetary values in alternate cells between cell Y2
to BK2 directly under row 2. Next paste all the monetary values below cell w2
(not V2) and the corresponding cheque serial number in cell X3. The
corresponding cheque serial number will always be positioned to the immediate
right of the cell containing the monetary value; for example if cell Y2
contains a monetary value then Z2 will contain the cheque serial number.
Please could this macro run for all rows between row 2 to row 10,000.
Cells Y2 to BK2 - alternate cells within this range contain monetary values.
Cells Z2 to BL2 - alternate cells within this range contain cheque serial
numbers.
I need a macro to do the following:
If the monetary value in £'s sterling in cell V2 is greater than £350.00, to
count the number of monetary values in alternate cells between Y2 to BK2. For
example: cell Y2, cell AA2, cell AC2, cell AE2 etc, etc. Add the same number
of rows as the number of monetary values in alternate cells between cell Y2
to BK2 directly under row 2. Next paste all the monetary values below cell w2
(not V2) and the corresponding cheque serial number in cell X3. The
corresponding cheque serial number will always be positioned to the immediate
right of the cell containing the monetary value; for example if cell Y2
contains a monetary value then Z2 will contain the cheque serial number.
Please could this macro run for all rows between row 2 to row 10,000.