Re: selecting specific columns with data and put it in a new sheet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Ok, I will try to describe it clearer :)
I am provided with a database which is approx 20000 lines and 140
columns. I don't need all the columns to produce a report on a monthly
basis. The last couple of months I build a excel document with various
pivottables wich selects data from certain fixed columns. Headquarters
decided to change the column layout of the database which effects the
pivottables I produce. To overcome changes in the future I want to
sort out the handed out database with the columns I need before I put
it into my mastersheet for the pivottables to do their job.
So the plan is that the macro looks in a range (in row format) on
sheet (for example) 'assumption' where the selected column names are
put in manually. It looks at cellvalue A1 and than tries to find this
column name in the database. When cellvalue is found in row 1 (of the
database) the macro than selects the complete column and copies it
into a new sheet in column A. By a loop it then looks for cellvalue A2
on sheet assumption and copies the found column in column B till the
end is reached of the searchrow in sheet assumption.

The idea is that instead of using the entire database, I am making a
pre selection of the columns needed. In this way the build
exceldocumnt is not effected by changes made by headquarters. With
the selection row in sheet assumption I will be flexible in choosing
rather than rebuilding the document again (pivottables etc).

Hopefully I am clearer now :)

.

Relevant Pages

  • Re: Auto Fill
    ... Therefore everything from phone calls to faxes to documents have to be logged into our database. ... From the fax table I already have a report that will be generated so that they can print the report out and use it as a cover sheet. ... I NEED both of these tables, as they are with all of their information so that I can see exactly where the item was faxed and to avoid people accidentally creating a wrong query and me never knowing it until it is too late OR having it be too complex and time consuming for them- it is much easier for them to be able to fill out a form and create the report. ...
    (microsoft.public.access.gettingstarted)
  • Re: Auto Fill
    ... I am working on a database that needs to keep track of everything we do ... report out and use it as a cover sheet. ... use a query or anything else. ...
    (microsoft.public.access.gettingstarted)
  • Re: Difficulties programming a command button
    ... My database field names are per your "i.e." below; ... The general format for the sheet labelling is "TechSurname ... helpful to add a field "WorksheetName" to the equipment table. ... now I need to modify it such that the particular sheet that opens is directly ...
    (microsoft.public.access.modulesdaovba)
  • Re: VBA code silently crashing. Problem with Data Validation drop down lists.
    ... experiences of running code in XL97 with faulty UDF's - it blinded ... > common is both make sql calls to an Access database using DAO 3.6. ... > dependents or precedents with any other sheet. ... > completely independent from the rest of the workbook. ...
    (microsoft.public.excel.programming)
  • Al Gran Fabricante De La Matriz
    ... The program opens to a sheet called the ... Once on a selected matrix sheet, the user may edit the tasks and/or employee ... the database and retireve all relative info and fill in the matrix. ... Also included in the workbook is the MasterDatabase which lists each ...
    (microsoft.public.excel.misc)