If you can figure this out, you're a genius!

jacobjacob

Board Regular
Joined
Oct 8, 2002
Messages
111
I have two excel documents.

book1.xls and book2.xls

book2 needs to be populated from book1. I do not know how to write a lot of function codes, so I need help.

I'm not only needing the document to populate from the other, but I also need it to calculate some equations based on the information in one of the books. I have a screen shot of what I'm trying to do, if you are up for the challenge, please respond, because I don't think this can be done, and need some advice.

Thanks
Jacob
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"If you can figure this out, you're a genius!"...but only because it would require mind reading! How about posting back with a more detailed description of the data in the soucre workbook, where it's held, where you want it in the destination workbook, what calculations you need etc. Consider using the html maker addin (see the link below this post) to post up a snapshot of the data.

More info please!

Paddy
 

jacobjacob

Board Regular
Joined
Oct 8, 2002
Messages
111
Hi Paddy!

Wow, I can't believe it's you! You helped me a long time ago on an excel problem I had. And I'm a student working on a project, so I really appreciate.


Okay, here goes! You will probably need to look at the image, but I don't have anyway, cause I can't use HTML on my computer right now.

book1 consists of several last names in column a.

book2 is an actual audit of an individual (one of the last names).

There are question answers in book1, and I need to take these answers, add them up, and populate them into book2, then I need to calculate an average.

Also, several answers have been submitted for each question. So that is the reason I have to calculate an average.

In book2, cell C8 asks for the total points received for Question 1a. I need book2 to scan and find the last name in book1 for the last name listed in book2 (cell B4). Then I need it to add up the score for Question 1a for that last name, and place that score in book2 cell C8. Then I need it to take that score and calculate the average between the available answers for that particular question.

There are a total of 28 questions. I think if you had a screen shot of what I'm talking about it will help. If you would like me to email it, send me your email address.

Thanks Again!
Jacob :)
 

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
"I think if you had a screen shot of what I'm talking about it will help"

Never a truer word spoken!

I'm fairly sure I understand your general need, but cannot take this any further without knowing precisely where each of your bits of data are (eg. book1, sheet2, col A, cells A1:A150 (including header in row 1).

Please be more specific...it would really help if you gave a worked example...

Paddy
 

Forum statistics

Threads
1,143,617
Messages
5,719,735
Members
422,242
Latest member
hishamkhatri

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top