V
Versace77
Hey everyone, looking for some help and not sure if it's possible. I tried
checking other topics but couldn't find anything relative.
i have a spreadsheet that people paste data to on the left side, (columns
a,b and c). The fields are Date, Voucher number (all unique numbers) and
dollar amount. A query from a retrieval system populates this same data on
the right hand side with. However, on the right hand-side there may be two
'like' voucher numbers where the monetary total adds up to the one total on
the left side. When this occurs we need to insert cells and shift down on
the left hand side to keep all the voucher numbers in sequence by row.
Looking for a macro to do this for me as there can be more than 50 separate
insert cell, shift cell down actions taking place daily and it takes quite a
bit of time.
Here's a drawing of what i'm talking about.
Before:
02/17/09 VVDA123 $4,400.00 02/17/09 VVDA123
$4,000.00
02/17/09 VVDA155 $2,000.00 02/17/09 VVDA123
$400.00
02/17/09 VVDA200 $950.00 02/17/09 VVDA155
$2,000.00
02/17/09 VVDA200 $950.00
I want it to look like this:
02/17/09 VVDA123 $4,400.00 02/17/09 VVDA123
$4,000.00
02/17/09 VVDA123 $400.00
02/17/09 VVDA155 $2,000.00 02/17/09 VVDA155
$2,000.00
02/17/09 VVDA200 $950.00 02/17/09 VVDA200
$950.00
Hope this makes sense to someone out there. The spreadsheet is rather large
as daily data is appended. If the macro would be too slow running through
the entire sheet would it be possible to have the macro work just on selected
cells?
Thanks in advance for any help here.
checking other topics but couldn't find anything relative.
i have a spreadsheet that people paste data to on the left side, (columns
a,b and c). The fields are Date, Voucher number (all unique numbers) and
dollar amount. A query from a retrieval system populates this same data on
the right hand side with. However, on the right hand-side there may be two
'like' voucher numbers where the monetary total adds up to the one total on
the left side. When this occurs we need to insert cells and shift down on
the left hand side to keep all the voucher numbers in sequence by row.
Looking for a macro to do this for me as there can be more than 50 separate
insert cell, shift cell down actions taking place daily and it takes quite a
bit of time.
Here's a drawing of what i'm talking about.
Before:
02/17/09 VVDA123 $4,400.00 02/17/09 VVDA123
$4,000.00
02/17/09 VVDA155 $2,000.00 02/17/09 VVDA123
$400.00
02/17/09 VVDA200 $950.00 02/17/09 VVDA155
$2,000.00
02/17/09 VVDA200 $950.00
I want it to look like this:
02/17/09 VVDA123 $4,400.00 02/17/09 VVDA123
$4,000.00
02/17/09 VVDA123 $400.00
02/17/09 VVDA155 $2,000.00 02/17/09 VVDA155
$2,000.00
02/17/09 VVDA200 $950.00 02/17/09 VVDA200
$950.00
Hope this makes sense to someone out there. The spreadsheet is rather large
as daily data is appended. If the macro would be too slow running through
the entire sheet would it be possible to have the macro work just on selected
cells?
Thanks in advance for any help here.