Shop Floor Control spreadsheet Vlookup Issues

[bossman137]

So here we go.

Running Excel 2012

Contains many sheets, but 1st sheet is Master/Summary, all others are simply copies of one another, serve to store data sets scanned in by a barcode scanner in a machine shop.

Attached Spreadsheet contains a macro that serves to act as a time stamp for columns 4 and 5 of all the copied spreadsheets.

My problem:

On the master summary sheet, I'd like to use a vlookup to copy the macro inserted date and time stamp, but if you look at my G6 and H6, they return some numbers and not the specified time and date.

[JO505]

Try formatting the cell to the desired values.

Jim O

[bossman137]

Ha I'm such a fool, thanks!

[JO505]

No problem, I do that far too often myself.

Jim O

[JO505]

You might also find an Indirect formula handy.

Please Login or Register  to view this content.

Jim O