You can imagine the time you can save and take up more challenging work for the day and of course get the accolades from your management. Now, suppose you have to send such reports for three projects. This saves time for you and you can do the mundane activity of reporting in just few minutes. Hence, it would be ideal to have information for the rest of the cells, every time you have to create the report. This leaves you with only two cells – C13 and C14 that need to be filled in by you every day. Further, in cell C15, you can have the formula C14/C12 and format the cell C15 as percentage to have the % Work Complete calculated by Excel for you. Of these also, in C3 (Report for Date) you can place the Excel function = TODAY () that places the date of your report without your intervention. Now, the report should be placed in the cell B2 and should be in the given format.Ī sample filled in report will be as shown below −Įxcept for the data in the following cells, the information is constant for every report that you generate for the project.
![absolute reference excel absolute reference excel](https://chrismenardtraining.com/_CMT/images/blogs/posts/featured/44.jpg)
Suppose you have to submit a report about your team’s work at the end of every day in the following format − You will learn about relative references in the next chapter.
![absolute reference excel absolute reference excel](https://cdn.lynda.com/video/75503-194-635184355309351633_338x600_thumb.jpg)
You will learn about absolute references for macro in this chapter.
![absolute reference excel absolute reference excel](https://i.ytimg.com/vi/EmYkBsnrvn4/hqdefault.jpg)
On the other hand, a macro recorded with relative references can perform the recorded tasks at different parts on the worksheet. A macro recorded with absolute references places the recorded steps exactly in the cells where it was recorded, irrespective of the active cell. Excel macros can be recorded either with absolute references or relative references.