Add Range to Array find Array value and Paste back to Range

[Foreverlearning]

Hi,

I am trying to work out (still learning Arrays) how to add a range to an Array then with each value in the Array find that value in
another sheet and add that value to the array and finally paste results back to worksheet.

What I have so far is adding range to Array and finding each array value..

Please Login or Register  to view this content.

I am still unsure how to add found value to the array and paste back onto sheet at a offset of 7 cells

Thanks

[JBeaucaire]

If the first value from C7 is found on the LAB83 sheet in cell B25, what exactly is supposed to happen? LAB83-C25 is pasted to activesheet-J7?

[Foreverlearning]

What I was trying to do is add the found value into array relating to value and then when all values are searched paste the results back onto sheet on offset of 7
The values are pasted back into Activesheet at a offset of 7

Thanks

[JBeaucaire]

Ok, can't visualize that. Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to automate.

[Foreverlearning]

Hi Jerry,

Thanks for helping out.

I have attached a sample workbook inserting random data, but with same framework.

I have added a note within the workbook.

Thanks

Lionel

[jindon]

3 examples

Please Login or Register  to view this content.

[Foreverlearning]

Hi Jindon,

Thank you for your input.

I will try the code out.

Lionel

[Foreverlearning]

Hi jindon,

Code did not return expected value
After dissecting I added some small changes and got result I needed

Please Login or Register  to view this content.

Is it now possible after examining my goal to place desired result in same cell as being divided by
and place in brackets.

Example 1st number to search is 102079 and value to divide is 7000 (column F)
result is 93.2

Objective = 7000(93.2) in same cell as 7000 (From included workbook earlier post)

Thanks
Lionel

[JBeaucaire]

I understand the fun with VBA, but doesn't this basic formula do what you described in your sample workbook instructions?

N8: =IF(C8="", "", F8 / VLOOKUP(C8, LAB!$B:$H, 7, 0))
...copied down.

[Foreverlearning]

Hi,

The worksheet is imported from another source and you basically start with a blank sheet.

Also I am trying to do all by VBA and hopefully arrays

[JBeaucaire]

Ok, good luck, then. If I were faced with this problem and "had to do it with VBA", I would use VBA to insert that formula and copy it down.

[Foreverlearning]

Ok,

This will not give me a solution as per my 2nd last post

Thanks anyway Jerry

I will slog it out until I find a solution.

Lionel

[jindon]

You mean like this?

Please Login or Register  to view this content.

[Foreverlearning]

Thanks jindon.

Everything now works as intended..