database

Hi I have been trying to search for a solution for days to no avail. Basically below code should take a specific value (C2) from ThisWorkbook and find if it exists in Sample Db (Column D), if it doesn't exist, it will populate a range of data (Column A to AI) from ThisWorkbook to Sample Db, if...

Hello! Here's a quandary I've been mulling over at work. I need to create a .xls that will: Connect to the org financial database, which is not editable and cannot be added to. Not a problem, as I have database access all set up. Display month-by-month revenue in a pivot table, with customer...

Hi everyone, Is it possible to display the number of grouped items as a value or as a bracketed suffix to the name? For example: Accessoires would show "Accessoires (12)" and Accessoires Indoor would be "Accessoires Indoor (39)" even though it is collapsed. Alternatively, B3 would show the...

Hi, I'm trying to connect to an SQLite database that contains financial information about various companies. The code will then put the information into a worksheet for me. Currently I am having to hard code the symbol of the company that I am wanting to search in the database for. This works...

Hi, I have written a VBA application which basically is using Excel as a database where data can be retrieved from another application, users can view the data and add comments, or additional data via a UseForm. The data is stored over multiple worksheets. Sometimes, users will ask for new...

Hello, I have a webstore that provides me with a csv file that gives information on everyone's orders. I get this csv file by manually clicking download on the website. I would like to regularly combine this csv file into a main excel file. Should I be using the "data", "Get&Transform Data"...

Hi I have googled my heart out over the last couple of days and tried 100's of different things but nothing is working so I am hoping one of you fine people can help. I have created a Database with a user form. I need to be able to open the files which names I have pointed out on the left hand...

Hello, I'm new to Excel and the database that I use is SQL Server Management Studio. While I have found it incredibly helpful to pull data from my database into Excel, I have not thus far found a way to push data to my database from Excel. While doing some research online, I found an Add-in...

I have a large Q&A spreadsheet with rows that include question, answer, category, sub category, and date updated. I am looking for someone to create a form in which I can search with the option of filtering by category. I am thinking a place to insert the phrase or question (and be able to...

Tossing this out to the Excel geniuses of the community. I need help creating a spreadsheet where I can associate an author’s statement to multiple keywords. I’ll have hundreds of individual statements with multiple keyword associations for each statement. I need to be able to search for those...

Dear friends i am in need of some help. i am quite new and learning. i have done some work on it but dont know how to continue now. So basically i have a ''master'' called sheet that has a list of students from A6 TO A36 and their student ids from B6 to B36 and from C6 to C36 to have their...

Can there be 2 identical Databases (2 worksheets) that synchronize both ways (insert to 1 updates 2 / update 2 - updates 1)? Here's the scenario I want 2 worksheets to be identical, where one sheet will contain A-P and the other Sheet will contain Q-Z. But if I update Worksheet 1 or 2 they...

Hello dear, it is a pleasure to be part of the Mr Excel community. My query is based on the following: I have a budget management system made in excel that uses a spreadsheet to make a certain budget and saves the information of each budget in another spreadsheet that is used as a database to...

Hi all. I prepared a small example database but it seems that I'm not allowed to post an attachment so I'll try and explain my dilemma by using one of the above tables. <tbody> A B C D E F G etc etc etc etc 39 6 23 34 2 7 26 8 3 35 18 22 7 23 2 39 6...

Hi everybody Long story short, I work for a construction company and I am in the process of making things much more efficient. I have built a small database in Access and have a connection pulling all that data into my workbook. Currently my database has 70 columns and will be expanded to...

Hello all. I'm a basic Excel user trying to create a spreadsheet for a friend - also a basic Excel user - who owns a dog grooming business. It will be your standard client list, with a few special columns like: Special Needs (like muzzle - will bite, or soothing oatmeal shampoo for skin...

Morning, I have a worksheet called INV that when i select the drop down arrow in cell G13 i see a list of customers names. These names are on another worksheet called DATABASE of which is in the same workbook. Selecting a name then copies certain cell values from the customers entered info on...

I have a Back End (BE) with all my Tables. When I am solely in the Front End (FE) Database everything runs fine. As soon as another user opens and uses the Front End database the database somehow is loosing the links. We get a message that it doesn't recognize the back end and we have to...

I am trying to disable the design view so user cannot make any changes. Greatly appreciate if you can help or what other option I can do to protect my database from being modified. Thank you!

Im trying to find a way of exporting one row of data from a spreadsheet into a database in Access. I ideally don't want access to open in this process as it sometimes causes everything to not respond. I had though about a simply recording a macro to copy & paste one row into access but I think...