Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

I need to read from the sheet1 and produce sheet2

Posted on 2014-11-27
14
Medium Priority
?
105 Views
Last Modified: 2015-07-04
I need to read from sheet1 and produce sheet2 as attached.

Regards,

Dallag
1.xlsx
0
Comment
Question by:Mohammed Dallag
  • 8
  • 6
14 Comments
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40468588
No attachment... Hopefully in attachment it will be clear how and what you want to accomplish..
0
 

Author Comment

by:Mohammed Dallag
ID: 40468590
I added that sorry and I need your urgent help. I can call you now to explain.
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40468614
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:Mohammed Dallag
ID: 40468625
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
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40468682
Is this the final number of columns ?
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40468684
Updated based on the new sheet1...
2.xlsm
0
 

Author Comment

by:Mohammed Dallag
ID: 40468716
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
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40468736
That is what i asked before, let me adjust it accordingly...
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40468751
Here it is...
3.xlsm
0
 

Author Comment

by:Mohammed Dallag
ID: 40472380
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
 
LVL 15

Accepted Solution

by:
Haris Djulic earned 2000 total points
ID: 40472912
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
 

Author Closing Comment

by:Mohammed Dallag
ID: 40473252
Thank you so much for your help
0
 
LVL 15

Expert Comment

by:Haris Djulic
ID: 40473269
You are welcome...
0
 

Author Comment

by:Mohammed Dallag
ID: 40866738
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question