Solved

I need to read from the sheet1 and produce sheet2

Posted on 2014-11-27
14
94 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
[X]
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
  • 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
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…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

734 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