Excel boffins
#15
Yes and no FF! Every time we create, factor or make a new part we use a template file to record basically what it is, where from, how much, brief description etc. Also how many we have at one given time. That data is all in the same cells for consistency, so easy to source, it’s just the summary file I’m struggling with. As said above, Access would be ideal for this.

Can’t network just yet but server going in next week I hope, then we will be able to network. That’s when I’ll go full ERP (probably same system as sister company across North Sea), so no point throwing silly money at it now. However creating these files has had value, since the new ERP will be able to read this data in very easily. I just need better inventory visibility in the meantime.
Reply


Messages In This Thread
Excel boffins - by HawkingsHalfpint - 11-22-2020, 10:50 PM
RE: Excel boffins - by MancBaggie - 11-22-2020, 10:53 PM
RE: Excel boffins - by Big Daddy Cool - 11-22-2020, 10:56 PM
RE: Excel boffins - by SausEggBaton - 11-22-2020, 11:32 PM
RE: Excel boffins - by baggiemike - 11-23-2020, 12:01 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 12:03 AM
RE: Excel boffins - by baggiemike - 11-23-2020, 12:21 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 12:37 AM
RE: Excel boffins - by Fulham Fallout - 11-23-2020, 02:40 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 06:46 AM
RE: Excel boffins - by Anung un Rama - 11-23-2020, 07:16 AM
RE: Excel boffins - by Fulham Fallout - 11-23-2020, 07:15 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 07:35 AM
RE: Excel boffins - by Fulham Fallout - 11-23-2020, 07:41 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 07:47 AM
RE: Excel boffins - by Fulham Fallout - 11-23-2020, 09:03 AM
RE: Excel boffins - by waffle - 11-23-2020, 10:18 AM
RE: Excel boffins - by HawkingsHalfpint - 11-23-2020, 02:22 PM
RE: Excel boffins - by hudds - 11-23-2020, 10:29 AM
RE: Excel boffins - by Fido - 11-23-2020, 10:47 AM
RE: Excel boffins - by Birdman1811 - 11-23-2020, 03:02 PM
RE: Excel boffins - by MassDebater - 11-23-2020, 04:17 PM

Forum Jump:


Users browsing this thread: