Solved

I need to read from the sheet1 and produce sheet2

Posted on 2014-11-27
14
86 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
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
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…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
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…

744 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

12 Experts available now in Live!

Get 1:1 Help Now