| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to lock-link cells?
You are a genius! Thank you so much!!
"Eduardo" wrote: Hi, Use Vlookup function =+VLOOKUP(A3,Sheet2!A:D,2,FALSE) Where Sheet2 columns A and B is where you have your information , in Sheet 1 cell A3 is where you enter the name and 2 means the column where you retrive the information If this was helpful please say yes, thank "petit.miette" wrote: I am working on a spreadsheet for a fund raising dinner. I have one worksheet that lists all guests, including hosts, table#, and seat#. Then, I have a series of other "donation tally" worksheets...one per table...that autofills host, guest, table#, and seat# based on the comprehensive worksheet. Right now, they are connected by cell location (i.e. Guests!B42). The problem is this...when the comprehensive worksheet is sorted or an extra "seat" is added...the tally sheets become incorrectly populated. Is there a way to lock-link cells, so that they are forever connected regardless of sorting or inserting additional rows? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I link/lock rows so they move together in a sort? | Excel Worksheet Functions | |||
| Lock Cells | Excel Discussion (Misc queries) | |||
| How lock just some cells | New Users to Excel | |||
| Lock all cells? | Excel Discussion (Misc queries) | |||
| HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
![petit.miette[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
