database management

Hi all I have an existing database in a worksheet, with customers arranged down the rows, and variables for the customers arranged along the columns. I then have a separate worksheet which acts as an 'At-a-glance' page whereby you choose the customer from a drop down list and a series of cells...

Hi all I have a populated data base where each row represents a customer, and each column represents a product. Some columns are subdivided where a product has variants. All I want to do is create a simple worksheet where a product can be selected from a drop down list, and then all the...

I have a database which contains a fair amount of data - some of which is confidential. This is not a shared database, however i will regularly need to send a "non-confidential" version of this out to colleagues. Is it possible to write a a set of code and attach this to a button to : 1...

Hi everyone, I'm currently tasked to handle a small project for a company I am interning at. I'm new to excel and so far my knowledge has been based off reading forums and guides online. I'm looking to create a macro that'll allow me to search through this Excel database through multiple...

Hi everybody, Briefly, What i'm trying to do is a program that creates a userform for each customer I have in a database with all the products they ordered, the details of them and a commandbutton that will work as a check. The userform helps me enlisting the orders. As every customer order...

Good Morning, this is my first forum, so please bare with me. I am producing a tracker for some people so that we can track and update any training that we need to complete and know when we need to complete it. What i am looking for is as follows. I a to have a database (I have made already)...

Hi Guys, I have just started a university society and am in charge of most of the admin. As part of this I need to keep track of members details. Currently we have an entry form set up via Weebly(a website building platform) which allows us new members to enter their details and subsequently...