Inserting data from one worksheet to another
 

I have a VLOOKUP on Sheet1. I would like to use a conditional on the
result of the VLOOKUP and insert the result into a cell in either
Sheet2 or Sheet3 (depending on the result of the conditional). I
would like to have a all the work done on Sheet1 and not have to put
any functions on Sheet2 or Sheet3.

Any ideas on how I can do this?

John

Inserting data from one worksheet to another
 

On Jul 9, 12:58*pm, jmholt wrote:
I have a VLOOKUP on Sheet1. *I would like to use a conditional on the
result of the VLOOKUP and insert the result into a cell in either
Sheet2 or Sheet3 (depending on the result of the conditional). *I
would like to have a all the work done on Sheet1 and not have to put
any functions on Sheet2 or Sheet3.

Any ideas on how I can do this?

John

Hi John

I may need some more information but from what I can gather, you want
results on page 2 and 3 based on data from page 1.

To do this you will need to code in VBA - do ot worry, it is not hard
core !!!

calculate sheet 1 to get the vlookup results

Start loop

filter the results to page 2 requirement

copy the data and paste special - values in page two and format as
necessary

repeat loop for page 3 to page n

end

Simple - you should be able to get most of your code using the macro
recorder function in Excel


Dougal Everingham
Kompas Consulting

kompas [Danish] (instrument) for determining direction or to give
bearing

m: +61 431 475 606
e:
w: www.KompasConsulting.com.au and w: www.linkedin.com/in/everingham