Linking Excel Formula to Folders on Desktop

keith2730

New Member
Joined
Jan 24, 2018
Messages
1
Hi,

I was just curious if this was possible - and could not find any further information anywhere else.

I am in the service business, for each of our service jobs that we perform there are many different steps to completing the job for example-- the quoting phase - receiving a purchase order - scheduled jobs - invoiced jobs - etc. I have an e-filing system set up that I would like to somehow link to excel if this is possible. I currently have a job folder for each job, and as the job progresses I "cut" the job folder, and paste it into the next step folder. Example: Job is in the quote folder- after job is quoted and we receive a Purchase order, I cut the Job folder from "Quoted" and move into "Received Purchase Order" folder.

I would like better visibility on our process and was curious if there was any excel formula that could sort the data based on my movement of these folders outside of excel.

If anyone has any insight on this or any ideas to help me track this without the double work of just manually tracking the movement of folders --- I would greatly appreciate it!

Thank you!

Keith
 

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Forum statistics

Threads
1,223,908
Messages
6,175,306
Members
452,633
Latest member
DougMo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top