Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tanner
 
Posts: n/a
Default copying adjacent cells with formula

I wonder if it's possible to use vlookup or some such function to call
and copy cells from a table.

I have a table such as:

product color units weight retails discount total cost

I want create a sheet where when I choose the product, the next cell
shows a dependent list of the available colors for the product
(something I think I already figured out), but then I'd like to copy
the adjacent cells, with formulas, from the product table. So if I
choose product A I get all the cells copied from that line to a form.

Hope that makes sense...and I really hope it's possible.

Thanks in advance,

Tanner

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default copying adjacent cells with formula

=VLOOKUP(A2,Sheet1!$A$1:$G$100,COLUMN(),False)

put this in B2 and copy across

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"tanner" wrote in message
oups.com...
I wonder if it's possible to use vlookup or some such function to call
and copy cells from a table.

I have a table such as:

product color units weight retails discount total cost

I want create a sheet where when I choose the product, the next cell
shows a dependent list of the available colors for the product
(something I think I already figured out), but then I'd like to copy
the adjacent cells, with formulas, from the product table. So if I
choose product A I get all the cells copied from that line to a form.

Hope that makes sense...and I really hope it's possible.

Thanks in advance,

Tanner



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tanner
 
Posts: n/a
Default copying adjacent cells with formula

Hi Bob,

Thanks. I tried this and it only partially worked. only the first two
cells copied over. Any ideas why?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default copying adjacent cells with formula

Should work for all. Do the rest have values?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"tanner" wrote in message
oups.com...
Hi Bob,

Thanks. I tried this and it only partially worked. only the first two
cells copied over. Any ideas why?



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tanner
 
Posts: n/a
Default copying adjacent cells with formula

It's kind of a complicated table that I'm looking up from. What I need
is to copy the formulas and values of adjacent cells based on the
choice made.

Item Color Quantity Weight Units/row
units/Pallet Total Weight
Paleo Beige 123 23.5lbs 42
144
Bergerac Grey 123 32 lbs 38
122


So if I have a drop down list on another sheet that chooses Paleo, then
the adjacent formulas and cells from the table would be copied over.
What makes it more complicated is that the color is a dependent list
based on the product chosen, but I can put color ahead of item and deal
with that dependent list that way. I just need some way, however, to
copy all those adjacent values and cells from the table. Something like
"lookup a value" then "copy cells from column c:g adjacent to this.

Maybe I should be doing this through a macro tied to a button.


Thanks again for your help.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible? DakotaNJ Excel Worksheet Functions 25 September 18th 06 09:30 PM
Shortcut in copying a formula that links 2 workbooks cthanson Excel Discussion (Misc queries) 0 April 26th 06 03:56 PM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 05:57 PM
quick way to copy-paste a formula linked to cells in another file iniakupake Excel Worksheet Functions 2 September 26th 05 03:56 AM
Copying formula to different cells L/P Excel Worksheet Functions 2 December 30th 04 11:37 PM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"