Auto populating and assigning numeric value to a number
This could be as simple as = Sheet3!A1 or if you have a table of data on one
sheet and a list with some elements from that table on the first sheet, you
may be looking at a VLOOKUP or INDEX. For example, if you have a list of
employees and their vacation dates on sheet 3 and a list of employees with
some other data on sheet 1, a VLOOKUP might go something like:
=VLOOKUP(A2,Sheet3!$A$1:$A$500,2,FALSE)
If you have an upload site and this is not confidential information, go
ahead and post the link.
" wrote:
Ok first things first, I want to autopopulate vacation dates from the
3rd spreadsheet into the 1st.
Right now I have EDO autopopulating into the 1st spreadsheet but these
are every 4 weeks where vacation is random.
I could forward my test spreadsheet to you if you wanted? I dont know
how involved in this you want to get, LOL.
|