Hello,
I posted in the wrong section since this probably has to do with VBA issues.
I hope someone can figure out why the data repeats in column T on the 'Input' sheet and doesn't match the data on the 'PartsData' sheet for the record.
I appreciate the help.
You cannot populate a non-contiguous range like that.
You will need to loop through the range
In col T -
You wanted to populate data from sheet "PartsData" col - AG,AH..,Ak respectively in T5 to T20 ??
Regards,
Thangavel D
Appreciate the help? CLICK *
Thank you for the reply. Can it be done another way? These cells will have possible paragraphs of information.
Yes that is how I want it populated from the Input sheet. When I clear and go back to the record the data isn't matching.
How about
Please Login or Register to view this content.
Thanks Fluff is that in more that one area of codes?
It simply replaces this lineIn you Change Event codePlease Login or Register to view this content.
I get a compile error sorry
Did you declare both Cl & i?
No I didn't how? Sorry I am not that familiar with how to do that please.
Last edited by fredfarmer; 03-13-2019 at 01:12 PM.
Add above the code in post #6:
Dim i As Integer
Dim Cl As Range
Just for the record, this thread follows on from https://www.excelforum.com/excel-gen...nge-issue.html
Wow it worked thank you very much for your help guys.
Please take the time to review our rules. There aren't many, and they are all important. Rule #5 prohibits duplicate threads. If you created a thread in the wrong place, do not create a duplicate. Click on Report at the bottom of your post and ask a Moderator to move it for you.Originally Posted by fredfarmer
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Okay Mr. Jazzer I will do that in the future sorry for the violation.
Glad we could help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks