Lookup Using VB Code

[cldcp00]

I am trying to get a bit of VB code that looks up a value in another spreadsheet and adds to the details already in the cell replacing the 1

The first spreadsheet is a summary of the second, but users have complained that they have to flick between the two sheets to make sense of the data.


Also in the cells that are not 100% take the actual percentage and add to ref code Example (49827 - 16%) this information is in Time coulum in the summmary spreadsheet.


Summary Spreadsheet

Data Spreadsheet

Thanks in advance for any help

[Richard Buttrey]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[cldcp00]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Sorry not done many posts - will try and follow your guidelines and Repost

Thank You

[arlu1201]

Do not create a new thread, edit the 1st post of this thread.

[cldcp00]

What I am trying to do is use a referenace number in a cell to look up another spreadsheet which has a piece of data that needs to be prefixed to the reference data in the cell.

The data coulumn in the summary spreadsheet is CQ Time

Example

Cell before

49827-1

Cell After look up

49827- 16%

All cells in the range D66-I396 need to updated using the reference number in the cell

Hope this has made it clearer

Thanks for you help


Summary Spreadsheet

Data Spreadsheet

Thanks in advance for any help[/QUOTE]

[Richard Buttrey]

Hi,

When you say another 'spreadsheets' are you referring to a completely different Excel workbook or a different sheet in the same workbook.

Either way it will be better for those giving advice if we can see the workbook(s) in question. Please upload it/them and add some sample manually calculated results explaining with a note how the results are calculated with reference to cell addresses / ranges.