If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Import cell value based on Todays date from a particular sheet where sheet name = todays date

Thread starter kmpcan
Start date Dec 5, 2014
Tags

import data need advanced validation

kmpcan

New Member

Dec 5, 2014

Hi Guys,

Here is the question, i am stuck with it. I have a workbook (lets name it Bag Inv. Nov 2014.xlsx) with 30 worksheets on it each worksheet is named as Nov 1, Nov 2, .... Nov 30. Each worksheet has inventory on it. so we use one worksheet each day according to the date.

Now I have a second worksheet(abc.xlsx) where i need to get the Total inventory ('[Bags Inv. Nov 2014.xlsx]NOV 28'!$I$85) no. amount from november.xlsx BUT that figure has to change every day according to that days date.

On November 28 I need this cell "'[Bags Inv. Nov 2014.xlsx]NOV 28'!$I$85"
On November 29 I will need this cell "'[Bags Inv. Nov 2014.xlsx]NOV 29'!$I$85"

next month new spreadsheet. please let me know if i have forgot to mention anything.