This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have a workbook with one sheet for every week. Within each sheet I need to pull in some information from the prior week. Instead of having to copy and paste every week, I would like to program a formula to just grab the information from the tab to the left of the current sheet.
I.E.
Sheet #1 has information in Cells J7 thru J49 that I would like to populate in sheet #2 under cells H7 thru H49. It doesn't matter which week I'm working in - I will always be referencing the same cells in the worksheet to the left of the current one. Is there a simple way to do this?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
One way
Sub previoussheet()
MsgBox Sheets(ActiveSheet.Index - 1).Range("e1")
End Sub
Don Guillett MVP Excel SalesAid Software *** Email address is removed for privacy ***