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)
Hello,
Can anyone help with the problem below....
I am trying to pull information from a previous sheet to new sheet. I used the VBA macro formula for "prevsheet".
In the new sheet (next tab) i used the formula
=Prevsheet(Indirect("W9")) to pull a number from Column W, Row 9. in the previous sheet The only problem is if i add a column in the previous sheet my formula will not change to "V9" it stays at "W9" which pulls in the incorrect number. I need my formula to change to the correct column if i ever decided to go back and add/remove columns. This is for Excel 2010.
***Post moved by the moderator to the appropriate forum category.***
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.
Hi,
Please search on Google for how to send a OneDrive/Google Drive link to someone.
Hello,
Is there another way to send to you? I have no idea how to make a link.
Hi,
I will now need to see your workbook. Please share the link from where I can download your workbook.