Johnsmith999
New Member
- Joined
- Dec 27, 2018
- Messages
- 3
Hi,
I want to set up a simple vlu loop to copy data from one sheet to another
and I want the loop to end when when the loop reaches the end of the list.
let's assume the list of items with prices (columns 1&2) is on sheet 1 and the vlu required (column 3) is on sheet 2
Its early days for me, I am trying to teach myself using utube videos etc. but can't seem to grasp the idea of variables and how they interact with do until, do while, next, etc.
Please help..
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
I want to set up a simple vlu loop to copy data from one sheet to another
and I want the loop to end when when the loop reaches the end of the list.
let's assume the list of items with prices (columns 1&2) is on sheet 1 and the vlu required (column 3) is on sheet 2
Its early days for me, I am trying to teach myself using utube videos etc. but can't seem to grasp the idea of variables and how they interact with do until, do while, next, etc.
Please help..
cake | 0.75 | tea | ||
chips | 1.20 | sandwich | ||
chocolate | 0.55 | pizza | ||
crisp | 0.70 | pastie | ||
curry | 2.50 | drink | ||
drink | 0.50 | curry | ||
pastie | 1.30 | crisp | ||
pizza | 1.50 | chocolate | ||
sandwich | 1.99 | chips | ||
tea | 0.75 | cake |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>