Hi
No idea if I should be even using excel for what iam about to ask. basically we have 2,200 files, each one is basically a freight sheet which shows, address, weight, dims, bla bla and what iam thinking of doing is starting from scratch and putting something in place where the user can enter / save / print details.
If we ship there again we would have some sort of search feature. data entry i guess, but I wouldnt know how to set something like this up.
( Not sure where the data would be stored for each destination )
At the moment sheet 1 is data entry, sheet 2 shows the address so we can produce a sticker and sheet 3 is where the data from sheet 1 shows up laid out in the official freight sheet form that we send to our freight company we use.
Can anyone even maybe point me to something, even if its basic and ill try and change it about to fit what we do.
Thanks
No idea if I should be even using excel for what iam about to ask. basically we have 2,200 files, each one is basically a freight sheet which shows, address, weight, dims, bla bla and what iam thinking of doing is starting from scratch and putting something in place where the user can enter / save / print details.
If we ship there again we would have some sort of search feature. data entry i guess, but I wouldnt know how to set something like this up.
( Not sure where the data would be stored for each destination )
At the moment sheet 1 is data entry, sheet 2 shows the address so we can produce a sticker and sheet 3 is where the data from sheet 1 shows up laid out in the official freight sheet form that we send to our freight company we use.
Can anyone even maybe point me to something, even if its basic and ill try and change it about to fit what we do.
Thanks