I know this isn't the most traditional way to run a stock list, but essentially what I'm trying to do is fully reduce the current stock of leaflets to zero. No new ones will be added to the stock amount. I'm using Exel 2003 and Windows XP.
I've got two spreadsheets, Sheet A that colleagues use for tracking requests for leaflets. They enter the amount requested under the column that represents the ID number of the leaflet.
The other, Sheet B is a list of these leaflets. The description in column A and the ID in column B. Column C shows the current stock level, this has been manually entered and won't change.
I want cell D2 in Sheet B to take the amount entered in cell D2 on Sheet A and display this here. Whilst I've been able to sort this bit, it's the next bit I'm struggling with.
I then want cell E2 from Sheet A to show up D3, F2 from Sheet A to show up in D4 and so on. I
I've got approximately 30 rows of different leaflets so was hoping there was either some code I could use or there was some function I could use to replicate this.
Any help would be greatly appreciated!!!
Thanks
I've got two spreadsheets, Sheet A that colleagues use for tracking requests for leaflets. They enter the amount requested under the column that represents the ID number of the leaflet.
The other, Sheet B is a list of these leaflets. The description in column A and the ID in column B. Column C shows the current stock level, this has been manually entered and won't change.
I want cell D2 in Sheet B to take the amount entered in cell D2 on Sheet A and display this here. Whilst I've been able to sort this bit, it's the next bit I'm struggling with.
I then want cell E2 from Sheet A to show up D3, F2 from Sheet A to show up in D4 and so on. I
I've got approximately 30 rows of different leaflets so was hoping there was either some code I could use or there was some function I could use to replicate this.
Any help would be greatly appreciated!!!
Thanks