Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Calculate the number of weeks the stock on hand will last
I need to calculate how many weeks my on hand stock will last based on the weekly demands going out 30 weeks (current limit of data for each item). Column A has the item code Column B has the On Hand stock (each row = 1 week) Column C has the weekly Demand Data example Cell B2 has 245 units as...- cashback
- Thread
- Replies: 23
- Forum: Microsoft: Office
-
How to remove external data links via Macro
I need to be able to remove external data links from sheets that are generated via a macro. The resulting sheets need to retain the data but no links. Copy / Paste / Values does not work and I cannot record the steps into a macro when I tried : Select External Data Range Properties then removed...- cashback
- Thread
- Replies: 8
- Forum: Microsoft: Office
