rcbricker
02-11-2005, 09:34 AM
There is an example of the spreadsheet attached.
Basically the sheet works fine with the formulas, however, there are a few things that will become cumbersome over time. The sheet has to be continued for each new month.
Column A (first sheet) has the initial values that are either credits or debits that exist by the company. Each row is a different company that our company owes or is owed. (names removed for confidentiality)
Column C is the concienment value that remains constant for each month.
Column D is the percentage owed by our company
Column E is the actual value owed
Column F - I are for recording weekly payments
Column J is the new credit/debit balance
Column A for all sheets but the first is a copy of the previous sheets column J.
This sheet feels clumsy and I think that instead of copying the worksheet each month that a VBA can be created that will create a new worksheet (promt the user to name the sheet) and have each of the columns copied over with the same working formulas. (unless someone can come up with a better format for this sheet. I think it looks badly bu cannot for the life of me figure out the formulas needed to clean it up) thanks for the help.
Basically the sheet works fine with the formulas, however, there are a few things that will become cumbersome over time. The sheet has to be continued for each new month.
Column A (first sheet) has the initial values that are either credits or debits that exist by the company. Each row is a different company that our company owes or is owed. (names removed for confidentiality)
Column C is the concienment value that remains constant for each month.
Column D is the percentage owed by our company
Column E is the actual value owed
Column F - I are for recording weekly payments
Column J is the new credit/debit balance
Column A for all sheets but the first is a copy of the previous sheets column J.
This sheet feels clumsy and I think that instead of copying the worksheet each month that a VBA can be created that will create a new worksheet (promt the user to name the sheet) and have each of the columns copied over with the same working formulas. (unless someone can come up with a better format for this sheet. I think it looks badly bu cannot for the life of me figure out the formulas needed to clean it up) thanks for the help.