- This topic has 2 replies, 3 voices, and was last updated 24 years, 2 months ago by
bungie.
-
Posts
-
-
Anonymous
Polybutylene.com thanks for the reply. My problem is to have cells in Excel accept specific data from a data base. Somehow there must be a method or function to be written in that cell that will point to the data base and uses that info to complete the calculation.Maybe a macro. But if my excel program has drainage, hot and cold water, stormwater etc as worksheets the writing of macro,s for each entry becomes a bore. Any suggestions? Incidentally, the data base will be one that I will construct myself.
-
Im working on it…
-
ITs been a while since i have played with excel but if you place the data base on a back sheet, then call the cells as you need them.
Macros can be recorded so that you only need do the actions, and excel will record it for you.Dunno if this helps.
-
- You must be logged in to reply to this topic.
