• 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.

Template Standard Formula's Column Repeat based on Company Number count wise

Status
Not open for further replies.
Gunasekaran

Gunasekaran

Member
Hi All,

I have the Standard Template in my Process, Based on Comp Count wise, this "B Column automatically Copy and paste next, next, next.( Including Formula & Color, same format )

Example - In Working Sheet, In Comp Code count as 3 mean, then automatically this MEP_ID Column will copy and paste three Times Like that.

after Remove Duplicate from "M" Column Value in "Working File Sheet"

Comp
MFG_ASIA_PAC_135
MFG_ASIA_PAC_862
MFG_ASIA_PAC_232

81755
 

Attachments

  • Template Details Fill automatically - Community.xlsx
    146 KB · Views: 2
Why start a new thread?
See my answer at your previous thread:

Update Template Information from working File automatically

Dear Experts, As a newbie to VBA macros, I've started working with Sheet Update, Range Consolidation, and a small, small macro. Unfortunately, I am struggling to update this Standard Template description information from the Master Working File automatically. (Because in between multiple lines...
chandoo.org
 
Status
Not open for further replies.
Back
Top