H,



That should work. Will try to have this for you tomorrow. Will be gone today.

HI,

After revewing the Sales sheet it has columns for "Dates". So It may be best to say "Sales Sheet_April-2. The same way you did the "Long" form. This way we can key in to the "Day".

Hi,

I need to revamp the Balance sheet. But, you have it "PW" can you tell me what it is?

HI,

In the sales sheet you have a "Before Sale" and "After Sale" how would you know which category to populate the data from the "Daily" sheet?

It would be based on the date of the daily balance summary. For instance if the daily balance summary file has "4/15/15" then that net sales figure needs to be entered into the sales sheet under the column labeled "4/15/15," under the appropriate store number.

The before and after parameters are based on the dates of the ad. So the macro would need to match up the date on the daily balance sheet and the store number and then find the cell in the sales sheet that matches up to both those parameters.

Does that make sense?

Hi,

Thanks. Can you provide me the password for the Sales sheet?
I need to make some modifications on it.

My copy of the "sales sheet" isn't protected with a password. Do you want me to repost it?

Oops! It's the Daily sheet.

No problem, it is "Ca$h"

Sorry the pw did not work. Can you send me the file with out the password active?

Try this one, it should be unprotected

Attached Files

Copy of Daily Balance.xls (28.0 KB, 7 views)

Thanks.

Almost done.

HI,

Another Questin about the Daily Bal sheet. In Column "G" you have "datedate" will that hole the date for the Daily balance sheet?

Yes, it will be the date of the balance sheet, such as "5/19/15"

HI,

Place this file and the files you want to update in the same folder.
Open this file and click the Test button. This should allow you to set the files you wish to update.
I havre "Path" set to "Thisworkbook" path. Thats why all of the files you wish to update needs to be in the same folder on your hard drive.
I modified the "Daily Balance" workbook. Take look at it.

Attached Files

	Jess709SalesTest.xlsm (19.0 KB, 6 views)
	Copy of Daily Balance.xls (37.5 KB, 6 views)