Drag down same value at multiple points in a column

gambit6

New Member
Joined
Jun 10, 2015
Messages
1
Hello,

This is what my file looks like:

[HR][/HR]

DateInv#DeptVendor Ref#Check#Payment DateAmt PaidInv AmtManager Name
11/01/2014300699ITCOOL331111111/10/2014$2,000.00$2,528.00SMITH BILL
1111111/10/2014$500.00SMITH BILL
1111111/10/2014$20.00SMITH BILL
1111111/10/2014$5.00SMITH BILL
1111111/10/2014$3.00SMITH BILL
355999HRAIR442222211/10/2014$600.00$1,025.00ATKINS WADE
2222211/10/2014$300.00ATKINS WADE
2222211/10/2014$100.00ATKINS WADE
2222211/10/2014$20.00ATKINS WADE
2222211/10/2014$5.00ATKINS WADE

<tbody>
</tbody>

[HR][/HR]
What I want to do is drag Columns B, C, D, and H (Inv#, Dept, Vendor Ref#, and Inv Amt) such that I can drag-down the same value until I reach the next value and then duplicate that value down. I would like to automate that process, since I'm dealing with tens of thousands of rows.

So, if I did that with Column B, for example, it would now look like this:


[HR][/HR]

DateInv#DeptVendor Ref#Check#Payment DateAmt PaidInv AmtManager Name
11/01/2014300699ITCOOL331111111/10/2014$2,000.00$2,528.00SMITH BILL
3006991111111/10/2014$500.00SMITH BILL
3006991111111/10/2014$20.00SMITH BILL
3006991111111/10/2014$5.00SMITH BILL
3006991111111/10/2014$3.00SMITH BILL
355999HRAIR442222211/10/2014$600.00$1,025.00ATKINS WADE
3559992222211/10/2014$300.00ATKINS WADE
3559992222211/10/2014$100.00ATKINS WADE
3559992222211/10/2014$20.00ATKINS WADE
3559992222211/10/2014$5.00ATKINS WADE

<tbody>
</tbody>
[HR][/HR]
As noted, this will be done for tens of thousands of rows. If I were to do it manually, it would take lots of time and the potential for error is high.

There are multiple points were the value changes in a column and a new value needs to be dragged down until the next value. Columns "check#", "payment date", and "manager name" already have been duplicated.

Are there any shortcuts for doing this?

Let me know if I need to clarify anything.

Thanks!
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

a massive zebra

Board Regular
Joined
Dec 1, 2009
Messages
87
You could enter this formula into cell J2 and copy down across to column L and down the to the final row of data:

=IF($E2=$E1,J1,B2)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,447
Messages
5,486,950
Members
407,574
Latest member
Greso

This Week's Hot Topics

Top