Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

I need to read from the sheet1 and produce sheet2

Posted on 2014-11-27
14
92 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
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 

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 500 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

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

792 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