Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto Fill & Replace
I was wondering if there was any way that I could fill out one sheet and have
that sheet be they key sheet, and then other documents would put in certain things for how I filled them out. |
#2
|
|||
|
|||
Kenny, could you try explaining that again? Maybe it's me. :) I don't
understand what you're looking for. Maybe others can't either. ******************* ~Anne Troy www.OfficeArticles.com "Kenny" wrote in message ... I was wondering if there was any way that I could fill out one sheet and have that sheet be they key sheet, and then other documents would put in certain things for how I filled them out. |
#3
|
|||
|
|||
You can use VLookup formulas to return data from the key sheet. There's
information on VLookup in Excel's Help, and instructions and examples he http://www.contextures.com/xlFunctions02.html and a sample with instructions he http://www.contextures.com/xlOrderForm01.html Kenny wrote: I was wondering if there was any way that I could fill out one sheet and have that sheet be they key sheet, and then other documents would put in certain things for how I filled them out. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
How do I auto fill blanks cells immediately below with the same i. | Excel Discussion (Misc queries) | |||
Auto fill option box disappeared | Excel Worksheet Functions | |||
Auto Fill Options | Excel Discussion (Misc queries) |