Adjusting Inventory and Accounting records and striking variance values

Hello everyone ~ My Name is Rebecca and I love in Chandler, Arizona. I am an accountant for a medical device company and have a major challange upon me. I consider myself and intermediate Excel user and can usually get by with what I know or take an existing spreadsheet for move forward with it. However, I have been given a huge task of "automating" our inventory system to our accounting system (of course they are 2 seperate programs). Without getting into too much "Accountant Terms" I need to be able to make adjustments on the financials every month end for variances. Now I know how to export all the data and create a basic spreadsheet with simple formulas and vlookups.... however there are so many different scenarios of "if" probabilities that its beyond my scope of knowledge and I believe it is going to take so serious macro creating. I am taking some advanced excel courses however for me to be able to comprehend this project could take months possibly up to a year to do it on my own... what I am looking for is someone who cna assist me in creating this spreadsheet. I don't want to simply pay someone to just do the work I want to be able to work along side with them and be tutored through the process.

If there is anyone that can help... please reply to this post.

Hello Rebecca and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

I'll change the title on this occasion as it's your first post but please note for the future. To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Hello Rebecca,

Based on your last sentence and what seems to be a fairly intensive requirement you may want this moved to our Commercial Services forum. Let me know if so.

Or you may want to break your overall requirement into several smaller discrete tasks and post a question about these in the Excel Programming / VBA....forum.

Maybe the thing to do is put together a simple workbook that contains tables of original data, add some typical results that you want to get after processing the data and explain, perhaps in narrative form, what rules should apply in order to move from the data to the results.