1

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".

2

Re: Excel as a DB, I ask for suggestions and a few help.

Holle;
The task very simply dares by means of one of the most powerful tools Excel whom "pivot table" is called. Actually, your initial basis should serve as the unit to the data for one pivot table which structure you select independently, depending on on each unit to the technician you want to count what total data.
After that, if it will be necessary to create forms/reports for the press, there is nothing easier, than the same macro to transfer already ready data to in advance developed templates.
The nested example on the basis of your file see. Finishing make.

3

Re: Excel as a DB, I ask for suggestions and a few help.

Aster32;

Aster32 wrote:

Holle;
The task very simply dares by means of one of the most powerful tools Excel whom "pivot table" is called. Actually, your initial basis should serve as the unit to the data for one pivot table which structure you select independently, depending on on each unit to the technician you want to count what total data.

Thanks for this interesting addition, I yet did not use it in operation. But it would be desirable automation of design of the printing form. That single line = technics unit clearly. I have a question of filling of lines of the form. There can be some lines which should to be transferred to the form. I thought to make out some lines to one unit of technics, and for form formation to use selection of several lines. But how to transfer to a macro that selecting some lines, they should be issued as one printing form.
Here question on VBA there is more.

4

Re: Excel as a DB, I ask for suggestions and a few help.

To tell the truth, it is not absolutely clear that you want to receive as a result. How much I understood, to the arbitrary selection of several lines from your basis can get as the information on the same object of technics, and on different objects. Your form ("list") contains in the title part of a field for information filling only about one object.
Also it is not clear that mean in your basis the lines concerning same unit technicians, containing same "the Code 1" and differing only under the column "Ed of amendment" - for example lines 17-21 sheets "Basis". If you have an information output to sheet "Basis" from an exterior source, and a line technicians concerning the same object can contain both different, and identical field values "the Code 1" - that weeding "the Code 2" etc. - to you are not necessary.
Simply leave in basis of a field since "Date" and finishing a field "Amount". A field "the Code 1" - rename simply into "Code". Near to a field "Code" - get a field "PETROLEUM PRODUCTS Name". Further do the pivot table how I showed in earlier enclosed example. In lines and pivot table substrings amounts of the various expendable materials concerning specific unit technicians will be added.
Further you will need to fill only with a macro title fields of yours of the list, and "" in it a pivot table part (though a macro, though pens as it is more convenient).
To put it briefly - change the approach to the task. Something to select on sheet "Basis" and to press the button launching a macro - incorrect algorithm for the decision of the given task. Make the pivot table, select in it necessary and press the button - so much more correctly.