Ditutup

Add Features to a Macro Enabled Spreadsheet

I have a Macros enabled spreadsheet that I import sales data into, which then works out profit on all sales (via page where I enter cost values to SKU's). I would like this spreadsheet edited to be able to accomodate a few extra features.

I would like the spreadsheet to be able to give me an overview of sales for the week/month/quarter/year, I would like it to automaticlly generate data of best selling product/biggest profit items etc.

I would also like to incorporate a stock control element, so I can enter when I buy stock, and it is deducted from the stock as and when it sells (through the use of SKU's) and then this data collated on a weekly, monthly basis to show how much stock is being used on a weekly/monthly basis which will enable me to see trends and also and easy way to see when we are running low on stock.

Best Regards,

Ben

Kemahiran: Perakaunan, Analisis Perniagaan, Excel, Kewangan

Lihat lebih lanjut: spreadsheet add macro enabled, spreadsheet accounting, excel macro how to, cost accounting spreadsheet, buy spreadsheet, best buy weekly, accounting see, 12 month spreadsheet, accounting overview, accounting cost, spreadsheet excel and accounting, spreadsheet (excel) and accounting, accounting works, accounting spreadsheet, excel macro add, data trends excel, add stock, add macros, spreadsheet sales, import data macro excel, excel cost accounting, control stock macro excel, macro spreadsheet, stock spreadsheet excel, cost accounting excel

Tentang Majikan:
( 3 ulasan ) Milton Keynes, United Kingdom

ID Projek: #4076896

5 pekerja bebas membida secara purata £228 untuk pekerjaan ini

svet63

Not good with Accounting & Finance but developing Excel macros since 1997. So, if you have a clear vision of what is to be achieved, I can be of assistance. Regards, Svet.

£250 GBP dalam 7 hari
(46 Ulasan)
6.1
weonlydo

Excel macros and I go way back. I would be honored to do this project for you.

£200 GBP dalam 7 hari
(5 Ulasan)
3.4
eried

Hi, do you have something more detailed about the things you need? I mean, like a template in the excel with some step/step about how to get each value? Thanks

£240 GBP dalam 15 hari
(6 Ulasan)
3.3
Hibatariq1

i understand SKU based inventory management. i will add features to your spreadsheet by which you will get qty/amount of stock at any time, most selling and most revenue creating inventory will be highlighted seperatel Lagi

£250 GBP dalam 7 hari
(1 Ulasan)
1.7
brandonward09

I design Excel Spreadsheets, Access databases, Macros and VBA Code on a daily basis for a fortune 50 company. I also have a Finance Degree.

£200 GBP dalam 7 hari
(0 Ulasan)
0.0