LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 48
Default Automation: Adding rows and pasting values

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding values for all rows in a range Alvaro Excel Worksheet Functions 7 October 7th 11 02:47 PM
Copy and pasting values of filtered rows Jammings Excel Discussion (Misc queries) 1 August 5th 09 06:45 PM
adding rows, pasting values then empty sheet misscharliebrown Excel Worksheet Functions 2 October 30th 08 03:07 AM
Adding validation fails with automation error [email protected] Excel Programming 4 February 13th 08 08:30 PM
pasting a formula without so much automation Scott Excel Programming 2 November 18th 05 06:03 PM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"