Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Scoring

Posted on 2014-02-05
15
Medium Priority
?
145 Views
Last Modified: 2014-02-06
Hi Experts,

I need do my code process this whole data of WB  in this location "C\Data G\" Folder.

in attached WB - Scoring G 02.xlsm Row Number 32 & 33 need to be replaced with WB xyz.xlsx row 3 to 4. after one set finish next row 4 to 5 then 5 to 6 till end.   I guess you understand what I mean.

Thanks
Scoring-G-V02.xlsm
xyz.xlsx
0
Comment
Question by:Naresh Patel
[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
15 Comments
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 39837472
In this forum each question should be self-contained and understandable in the question text, and each answer (with unavoidable exceptions) be readable in the answer text.

In this question, the difficulty (as opposed to the requirement) is not apparent, especially since at least one for the attached files needs a password to open it
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837482
Sure Mr GrahamSkan,  but right now I am not in position to post detail query. I am not in front of my machine.posting this comment via mobile phone. I will as soon as possible.

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837488
is this what you want ?

the file is set to be at
C\Data G\xyz.xlsx
if it is not there make sure you change the location in the macro.

activate macros and press on process workbook.

chk results.
gowflow
Scoring-G-V03.xlsm
0
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 8

Author Comment

by:Naresh Patel
ID: 39837498
Sir gowflow, sure I will tomorrow.

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39837517
@GrahamSkan
your entirely correct. Have advised asker (this is a continuation of 3 previous questions) that file should not be password protected.

@Itjockey pls provide password so to give equal chance to all experts in questions asked.

gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39838659
here it is Unlocked file.

Thanks
Scoring-G-V02.xlsm
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39838669
Sir gowflow,

This regarding your this Post.

I had checked - thing is that total counts in xyz.xlxs file there is 45 data point to process where row 3 don't have enough data as it is starting point. so total count must be 44. 22 for HIGH & 22 for LOW.

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39838925
No I count every pair as 1

and I copy by pair like
Row 3 and 4 in 32,33 analyse then
Row 5 and 6 in 32,33 analyse then
Row 7 and 8 in 32,33 analyse
etc...
till last row

Is this the correct way ? I did as you explained.
gowflow
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 39838955
I read you post again and I think it is my mistake you want
3-4
4-5
5-6
etc..

try this version I fixed also percentages for low.
Now it make sense I like it
:)

gowflow
Scoring-G-V04.xlsm
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39839001
my bad Sir start with 3 to end.

Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39839018
meaning ? did u try the file ? I start at 3 and finish at the end !!
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39839091
actually I dint refresh the browser & posted comment. after that I seen. yes it is perfect.


Request need to add line from very first phase of this question series. will you ? as I goes on reading that point come now only. I think you wondered why don't I read all that stuff at once & then post question but it is too confusing so I go one by only.



Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 39839202
no problem. Are we done with this one ? is it working fine ?
pls post link to any other question
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 39839262
here it is the link Scoring.
0
 
LVL 8

Author Closing Comment

by:Naresh Patel
ID: 39839267
Excellent
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
New style of hardware planning for Microsoft Exchange server.
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

688 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