look up problem

  • Thread starter Thread starter chimp
  • Start date Start date
C

chimp

I hope this makes more sense to read that it does as i am typing it.


my current spreadsheet is almost at a final stage, but i do have on
more requirement, my spreadsheet is very limited to current stocks o
cars and does not allow me to include new cars to my garage.

the cars are entered in as code in the editor.

i would like to hear of a better way of doing this please.

i could do with, on the data tab of my sprerdsheet a button to add
new car, the new car to be added to the current list of viechles.

but then the userform on my sales worksheet to look at this list an
carry out all the functions that are currently used, such as cascad
depending on the manufacturer, and then search for the selling pric
accordingly.

i would also need the car to be added to the worksheet named Londo
within the relevant manufacturer, and then to include all the formul
as for the other cars.

Cheers

Andy



My spreadsheet can be found here


http://www.btinternet.com/~chimp8471/


also posted here

http://www.mrexcel.com/board2/viewtopic.php?p=327446#32744
 
I have an idea that you spreadsheet is nowhere near the "final stage" if
that term means the same as "ready for use". Please try to explain the
SPECIFIC stumbling block you have encountered and what you have tried in an
effort to resolve it?
 
i am nearly at the stage of completing my spreadsheet, but just have one
or two other things to finish off.

so here is where i am at the moment.

i am trying to populate the london , birmingham, cardiff and glasgow
sheets with the list of cars that are present in the "data" worksheet.
that i uploaded today. this list may grow depending on the addition of
new cars, bearing in mind that the list of cars may grow in size so
therefore each branch will need to accomadate this.

someone on another forum offered me this code, but i am unsure where to
put it.

SHEETS(\"LONDON\").SELECT
RANGE(\"A65536\").END(XLUP).OFFSET(1, 0).SELECT
ACTIVECELL.VALUE = CBOMANUFACTADD.VALUE
ACTIVECELL.OFFSET(0, 1).VALUE = TXTEDITIONADD.VALUE
ACTIVECELL.OFFSET(0, 2).VALUE = TXTLONCOST.VALUE
RANGE(ACTIVECELL.OFFSET(0, 3), ACTIVECELL.OFFSET(0, 5)).FILLDOWN
ACTIVECELL.OFFSET(0, 6).VALUE = \"\" 'CHANGE THIS TO WHAT GOES IN
COLUMN G
RANGE(ACTIVECELL.OFFSET(0, 7), ACTIVECELL.OFFSET(0, 16)).FILLDOWN

the link to the open forum is

http://www.mrexcel.com/board2/viewtopic.php?t=70072

and the link to my almost complete spreadsheet is :

http://www.btinternet.com/~chimp8471/Latest.zip

i really would appreciate any help in my final stages of this please.

cheers

Andy
 
Back
Top