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:



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>


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:




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>

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!
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
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)
 
Upvote 0

Forum statistics

Threads
1,213,524
Messages
6,114,117
Members
448,549
Latest member
brianhfield

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top