Solved

I need to read from the sheet1 and produce sheet2

Posted on 2014-11-27
14
88 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:dallagmm
  • 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:dallagmm
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
 

Author Comment

by:dallagmm
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:dallagmm
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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:dallagmm
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:dallagmm
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:dallagmm
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Search Workbook, then move rows to new sheet 13 31
Office 2016 Excel Issue 4 26
Add a range in an Excel graph 5 31
NEED TO UPDATE DATA IN EXCEL 18 29
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now