Hi, I am looking to automate my stock keep as best as possible with excel, I have a stock list already but it is taking too long to manage.
Please help me solve the following problems:
I want to add PDF info to excel documents but columns seem to be seperated by ?
How can I change it, by function or file format so it can be copied properly into excel?
How can I use functions and formulas over multiple sheets?
I am looking for a quick sort mechanism, how can I have a button at the top to quick sort a column?
Using Ebay etc I can download a csv results of what has sold, how could I add this data and have it so it automatically changes stock amounts?
(just general example is fine)
Sorry it is a bit much, just easier to go through all my problems in one go.
Thank you for any help you can provide.
Bookmarks