• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto Cell population for multiples / Duplicates

E

Emerson

New Member
Hi,
I have a spreadsheet with 2000 lines of data which needs to all be populated however some of the Reporting Field names are duplicates and i dont want to have to keep populating the same info overagain. What i want to be able to do is (using the example) When i enter content in Col D for a description it will autopopulate the relevant cell in Col D where the name has been duplicated within Col A. Example: in D1 i type Number which is the Description of the word Account# showing in A1. Is thier a way that i can then have cell's D10,18 & 26 autopopulate with Number as the Account# is duplicated in Col A instead of having to type number in the relevant D cell individually. Probably not but wanted to ask as i am feeling a little bit of my soul dying at the moment. Any advice or alternative solutions are more than welcome.
Thanks
Emerson
 

Attachments

Just for my understanding, the sheet you attached, in that sheet you would like to put a number in B2 which should duplicate in b10, b18 and b25, is that correct?
 
This is all possible, but I'm not sure I follow you above description of where you data enter and what needs to happen...
 
Sorry, not the best explanation but it does make sense in my head Honest. Right:
Abhinav, i am actually writing the word "Number" and am guessing you meant D not B for Col. :)
Abhinav/PaulF, What i would like to happen is when i Type "Number" in D2 which is my description of the content in A2, wherever the content in Col A is duplicated (in this case A2,10,18 26 with "Account#") the content of Col D will autopopulate with the word "Number" against the relevant cells of D10,18 & 26 so instead of me having to type it 4 times i only have to type it once. As mentioned i am working on a sheet that has over 2000 lines of data so want to try to reduce the work as much as possible. Thanks Again
 
Dim i As Integer
Dim j As Integer

Dim k As Integer

i = 2

Do While Cells(i, 2).Value <> ""
If Cells(i, 2).Value = Cells(2, 5).Value Then
j = i + 7
k = i + 1




Range(Cells(k, 2), Cells(j, 2)).Copy
Range("E3").Select
ActiveSheet.Paste



End If

i = i + 1
Loop


try using this vba code. You can assign a button to it as well. I am not sure how experience you are in excel so I have avoided using any offset values.

Thanks
Ab
 
Hi Narayan,
Thanks for the reply, I have tested the VLOOKUP and in theory it would work if all of the cells from D10 and below are blank. Unfortunately the actual document which is over 2000 lines has already been populated with some information at various points which from what I have tested would clear other contents already populated.
Thanks for looking.
 
You must log in or register to reply here.
Back
Top