Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding values for all rows in a range | Excel Worksheet Functions | |||
Copy and pasting values of filtered rows | Excel Discussion (Misc queries) | |||
adding rows, pasting values then empty sheet | Excel Worksheet Functions | |||
Adding validation fails with automation error | Excel Programming | |||
pasting a formula without so much automation | Excel Programming |