PDA

View Full Version : Seeking assistance on automating some functions in Excel



LivelyDesign
04-12-2012, 07:53 PM
I have a spreadsheet that has some macros and formulas in it that I need to add a few additional features to:

1. Create a copy each month to be saved as name of month ending for reference.
2. Copy ending inventory from saved sheet and input into new months starting inventory.
3. Clear contents and on multiple worksheets (this code is already in place but needs to be added to following functions).
4. Unlock item description cells for renaming products and then locking cells after changes made.

I am willing to donate to the person that helps with this project.

Thanks in advance.

Lynn

Aussiebear
04-13-2012, 02:01 AM
Normally speaking, one issue at a time is the usual protocol. How big is your workbook? Can a sample be provided so that we can assist you?

Bob Phillips
04-13-2012, 02:20 AM
1. Simple BeforeSave event code will manage that.

2. Needs more, much more, detail.

3. Which cells, which worksheets, which functions?

4. Needs more, much more, detail.

LivelyDesign
04-13-2012, 05:54 AM
Worksheet name: Copy of Monthly Inventory Sheet - Master 1

Worksheets:
Current Inventory
Day 1
Day 2
Day 3
Day 4
Day 5
Day 6
Day 7
Day 8
Day 9
Day 10
Day 11
Day 12
Day 13
Day 14
Day 15
Day 16
Day 17
Day 18
Day 19
Day 20
Day 21
Day 22
Day 23
Day 24
Day 25
Day 26
Day 27
Day 28
Day 29
Day 30
Day 31
Calculator
Month End

Columns on Current Inventory sheet (Displays running inventory from mont calculated on "Calculator" worksheet):

Entire "Current Inventory" worksheet protected

A = item number
B = description
C = TWIN
D = FULL
E = Queen
F = KING
G = TWIN
H = FULL
I = QUEEN
J = KING

Day worksheets:
All "Day ?" worksheets protected except for C3 - C62, D3 - D62, E3 - E62, F3 - F62, N3 - N62, M3 - M62, O3 - O62, P3 - P62, Q3 - Q62
C - F are for items sold counts daily
M - Q are for items received counts daily

All calculations are done on hidden columns after column Q on Day worksheets

Calculations for running inventory is done on Calculator worksheet.

Month End worksheet gets totals for monthly item sales and items received for the month.