This is my first time posting on this forum, so please excuse my ignorance regarding this process. I need assistance with building a Macro. I've attached the sample files.

I am attempting to automate a process which is currently manually entered into Excel. We receive daily balance sheets from our 21 stores and I need to have certain figures pulled from the balance sheets into two other Excel files. I've included an attachment of the sample files. Please assume that I will house all the files in the same folder, to make things simpler.

What I need to accomplish is: Pull the contents of cell C3 from the "Daily Balance" file and enter it into cell B4 in the "sales Sheet" file. I also need the contents of C3 from the "Daily Balance" file entered into B17 in the "Long Form April" file.

This would be an example of 1 day's balance sheet. I would need to duplicate the macro to complete this same task for the other days of the month. This would mean that C3 on the "Daily Balance" spreadsheet would remain constant, but the cells in the "Sales Sheet" and "long form April" would change based on the day of the month in which the daily balance sheet is for.

Please let me know if any additional information is needed to provide assistance.



Thank you in advance!!

Attached Files

	Daily Balance 4.15.15.xlsm (12.9 KB, 11 views)
	Long Form APRIL.xlsm (12.9 KB, 12 views)
	SALES SHEET.xlsm (64.5 KB, 11 views)