Re: excel tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

OK I'm still on 2002.

Point taken. But I think the user is still on a version lower than 2007.
Anyway way glad to know there is something else save for exceedingly large
files and a new menu bar.

Have a good new year.
--
Martin


"orbii" wrote:

hmm i'm using excel 2007, and i can... so try it :)

happy new year! orbii

"Martin Fishlock" <martin_fishlock@xxxxxxxxxxxxxxxxxxx> wrote in message
news:CE6DE5DF-4BAB-4E0C-BCAE-7C365BE7BD31@xxxxxxxxxxxxxxxx
Orbii as the previous repliers mentioned you cannot link directly to
another
***, either name the name and use the name range or use the indirect
function as:

=indirect("Sheet1!A1:A3")

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"orbii" wrote:

kinda odd if you ask me. it wont' allow you to select another ***
while
making the list, but it allows you to type in another ***'s name!R:C.

anyways, if you prebuild the string =Sheet1!A1:A17 should work too

cheers, orbii


"geo" <roberts_g@xxxxxxxxxxxxxxxx> wrote in message
news:%2369VIP5KHHA.5104@xxxxxxxxxxxxxxxxxxxxxxx
I don't think Data Validate will work. I'm not able to pull the data
from
worksheet1 to worksheet2 (the purchase order) using data validate unless
it
was all on the same ***.

Work*** 1

UNIT COST SCREEN GRILLES
2535 $ 130.46 $ 14.63 $ 19.10
2541 $ 144.01 $ 16.00 $ 19.10
2559 $ 154.65 $ 20.11 $ 19.10
2941 $ 163.04 $ 16.92 $ 28.04
2965 $ 177.23 $ 22.40 $ 41.44
3341 $ 142.07 $ 17.83 $ 28.04
359 $ 132.72 $ 21.94 $ 28.04
3365 $ 246.27 $ 23.31 $ 41.44
3371 $ 259.81 $ 24.68 $ 41.44
3747 $ 155.5 $ 20.11 $ 36.98
3757 $ 165.30 $ 22.40 $ 36.98
3759 $ 227.50 $ 22.85 $ 36.98
4159 $ 214.0 N/A $ 37.03
5953 $ 234.5 N/A $ 48.56



Work*** 2 - In this work*** I want to be able to pick from the
parts
table
enter in quanties and have the cost added up accordingly.

UNIT QTY COST QTY SCREEN QTY GRILLES LOCATION
2541 1 $ 144.01 1 $ 16.00 $ 19.10
KITCHEN









SUB TOTALS: $ 134.01 DINING ROOM
TAX: $ 11.73 KITCHEN
TOTALS: $ 145.74 LAUNDRY


"Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx> wrote in message
news:%23Az$GJ5KHHA.3560@xxxxxxxxxxxxxxxxxxxxxxx
Use Date Validate -> List to select the item
Use VLOOKUP to get costs
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"geo" <roberts_g@xxxxxxxxxxxxxxxx> wrote in message
news:O3D9zF5KHHA.1240@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

I have a workbook with a two worksheets.

Worksheet1 is like a parts table it has a listing of parts (windows)

Window item, Cost of window, cost of screen, cost of grill.



Worksheet2 is like a purchase order.

I want to be able to select items from the parts table in my purchase
order? I'm not real sure the best way to do that?

Thanks,
Geo











.

Quantcast