I have attached an excel file as an example of my troubles. Basically, I have a file with two worksheets. Sheet 1 "PB Inputs" has a time value as "6:00AM" for example, and I am trying to have that value go to Sheet 2 "Machine". Every time on the 'Machine" sheet when I put B2= ('PB Inputs'!D3:E4) I get #Value!. WHY?????? ?????
I figured this would be simple, but I guessed wrong.
Thanks
Bookmarks