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

Repeat cell value with said value and auto adjust data accordingly

N

Nabeel

Member
Dear All

in attached sheet, i have a data(which will vary as per my need) in sheet 2 and I want result in sheet 1 that repeat cell rows value with given figure(which is in column N in sheet 2) in sheet 1 and also adjust these value in columns as per their headers in sheet 1 and others data(yellow highlighted) will remain same and auto appear and disappear in their columns(if any change required in sheet 2), and all data should convert in upper case..!!yellow highlighted are constant their will no change in any case and blanks column will remain blanks..

i share only sample data it can be large and differ...

need your kind help on this
 

Attachments

  • PROMSAT 50 - JAN.xlsx
    14.2 KB · Views: 3
Dear Vletm
thanks for the help, this is great and working as per my need this is little slow can you make it little fast and data is not showing in column W in sheet 1, pl also data should in upper case in sheet 1....thanks

Nabeel
 
Last edited:
1) A little faster - What do mean Your term 'slow'?
If too slow then try to relax...
2) column W - what data c/would be copied?
Is there (Sheet2) [FULL_N_SUB] -column?
3) Now UPPERCASE too ... which makes slower too.
 

Attachments

  • PROMSAT 50 - JAN.xlsb
    24.2 KB · Views: 1
Dear vletm,
Slow means that when i hit do it button its takes 3 to 5 minutes to perform complete activity but i can go with it....
Yes Full_N_SUB also need to copy which data already in column s in sheet 1 or in sheet 2 in column J...
Means data which is in column J in sheey 2 will copy to in 2 columns in sheet 1 in columns S and W..plz


Nabeel
 
Hello

May be.

*********Use this before the code
Application.Screenupdating=False
Application.Displayalerts=False



*********Use this after the code
Application.Screenupdating=True
Application.Displayalerts=True


You will find big change in the speed...Let me know any challenges..
 
Hello Nabeel.

@vletm Good Job

It works less then a minute for me...may be due to less data..

It should work.

As

Screenupdating will reduce time by 75%..

Monty.
 
@Nabeel ... hmm?
1) Slow 3-5 minutes? really ...
for me it takes less about ONE second, cannot make it shorter time!
2) It would much easier to write what do You want, not what do You think!
 

Attachments

  • PROMSAT 50 - JAN.xlsb
    25 KB · Views: 2
Dear vletm
may you are rite, at that time it was taking enough time because i was restarted my laptop two time may it could be error of my system, now its good, sorry for inconvenience...!!
kindly amend my last issue sir...??pl

Nabeel
 
Dear Monty,
thanks for everything, i have a great respect for all of you, all the expert are doing great job here to helping others..!!this is great
Great both experts, still one issue pending which i have mentioned in post #05

Nabeel
 
@Nabeel
Do You mean:
Means data which is in column J in sheey 2 will copy to in 2 columns in sheet 1 in columns S and W..plz
Did You check the newest version?
Or what
still one issue pending which i have mentioned in post #05?
Or is this something else
what do You only thinking but not writing?
 
Dear Vletm
yes, i have checked, its not showing data in sheet 1, i highlighted with gray..???

Nabeel
 

Attachments

  • PROMSAT 50 - JAN (2).xlsb
    23.2 KB · Views: 2
Dear Vletm

You are great sir…!!!

This is now great working as per my need; I really appreciate your skill, knowledge, patience, temperament and understanding with work, I have to almost 2000 data upload on Monday hopeful it will work fine and no further issue will find and this will reduce my lot of time, every saving of time I have best wishes for you with prayers. Thnx a lot


Thanks to Monty as well

Nabeel Gondal
 
You must log in or register to reply here.
Back
Top