Jess709
New Member
This is my first time posting on this forum. I'm in need assistance with building a Macro. I only have the very basic knowledge of macros, so the complex macro that I need to formulate has been very challenging to even attempt.
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!!
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!!