I need to read from the sheet1 and produce sheet2

I need to read from sheet1 and produce sheet2 as attached.

Regards,

Dallag
1.xlsx
Mohammed DallagPetroleum ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Haris DulicCommented:
No attachment... Hopefully in attachment it will be clear how and what you want to accomplish..
0
Mohammed DallagPetroleum ConsultantAuthor Commented:
I added that sorry and I need your urgent help. I can call you now to explain.
0
Haris DulicCommented:
Hi,

please find attached excel with added 3rd sheet . when you click on the Get Data button it will preprare same table as in sheet2 based on the sheet1 . If you change the values just preserve the naming of the sheet1 first row...
1.xlsm
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Mohammed DallagPetroleum ConsultantAuthor Commented:
Thank but I have two things not working.

1. If I add one column more to the input it will not work. I need to read all the clumns added and they are not limited to two

2. the title of columns should as updated now in sheet1

Regards,

Dallag
2.xlsm
0
Haris DulicCommented:
Is this the final number of columns ?
0
Haris DulicCommented:
Updated based on the new sheet1...
2.xlsm
0
Mohammed DallagPetroleum ConsultantAuthor Commented:
I added clomn number 4 and it is not workong. I need the script to be able to know how many coulmns there.

Regards,

Dallag
3.xlsm
0
Haris DulicCommented:
That is what i asked before, let me adjust it accordingly...
0
Haris DulicCommented:
Here it is...
3.xlsm
0
Mohammed DallagPetroleum ConsultantAuthor Commented:
I tried my data in the same excel sheet and I got error and next time I got noting. Could you check please? The data already copied in the attached file.

I need this urgent.

Regards,

Dallag
5.1.xlsm
0
Haris DulicCommented:
Hi,

the issue was with the number of columns now i changed it and it works .. It takes some time but it gets the job done :).

Fur urgent issues send mail in case that i miss the comment here...
5.1.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mohammed DallagPetroleum ConsultantAuthor Commented:
Thank you so much for your help
0
Haris DulicCommented:
You are welcome...
0
Mohammed DallagPetroleum ConsultantAuthor Commented:
Hi Haris Djulic.

Still there is a limitation on the number of columns. If the number of columns exceed 200 I am getting the attached error.

Please help in this.

Regards,

Dallag
7-4-2015-3-42-32-PM.png
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.