Topic: Excel as a DB, I ask for suggestions and a few help.
Kind all day, with coming .
Prompt please a variant of design of a DB in Excel.
That was earlier:
Created in Excel the list from a template and saved in a folder as a separate file of everyone of the list on months/years, it is simple that was, them accumulated much. The fact is necessary simply that such created the list.
The printing variant left in accounts department/in business/in .
That I (but it is yet beautiful) made:
Created a uniform file with several sheets where all information and the necessary data is stored at once are visible on one sheet. Necessary lists can be selected and unpacked simply by the button. Repeating operations to make "line by line", than "" easier.
The description of my Frankenshtejna (gathered on slices):
1. The list template which is filled with a macro from DB sheet
2. Actually DB where are brought the data and stored
3-4. Sheets for substitutions
That is required:
I can not think as to issue input of several lines in "a list Template". Now made - single line = one list, some columns of a DB which are translated at lines for "a list Template" are for this purpose selected, I feel is issued clumsily.
I search for a variant how to issue a macro that it processed some the selected lines as one list, but I will not think.
.. Re-read and understood that for understanding it is necessary to select the main in the help - you Select some lines and from this the list on one technics with several lines "the Name /" which is formed were in the selected lines.
.. Though it is possible someone at once defeats all this idea utterly and it is necessary to make out all in Access with the subsequent setting to users.
The moderator: the Subject is transferred from a forum "Other DBMS".