data base

  1. D

    Hyperlinking Cells not Working

    Hi!!! I'm working on a data base where I need to link cells to another sheet, but its not working and i keep getting the "Cannot open the specified file" message. Even the simplest way using =HYPERLINK('Other sheet'!A509) When i use de manual option "Ctrl+K" it does work. But I need to link...
  2. M

    Define excel formula or vba code

    Hello there and I definitely need some help from someone to find a formula or a vba code for my column D. Situation: I'm building a Excel sheet to act as a database and I want some automation. In column A I have a formula for an incremental counter (starting from 1 counting up to 63655 when...
  3. C

    Syntax Error: Crosstab to Flat File Macro

    I recently came across a macro designed to convert crosstabular data to database ready data. You can find the post here... I've recently found a macro that will allow me to convert crosstabular data to a data base format. (You can find it here...
  4. M

    Managing data that regularly updates

    I've recently started sports blogging and I'm looking to do some statistical analysis. I've used a web scraper to record various statistics (Shots, passes, possession etc.) in all major league soccer games for the last 5 years. It looks something like this: <tbody> Home Team Away Team Home...
  5. C

    Auto Fill individual excel forms for each name on spread sheet

    Hello, I have a list of people that need to be sent letters. I have already created a form that will poplulate the letter based on the information input manually. I would like to take it to the next level but auto popluating the letter but pulling information from the data provided in a spread...
  6. C

    Excel / Database

    Hello everyone, I've been searching for(unsuccessfully) a way to create a form in Excel where people can go in and select multiple items from drop down menus then enter the information for the items. Once the form is completed they can select an "enter" button and the form distributes the...
  7. D

    Linking data in reverse

    Hi all, I have created a workbook which consisted of one worksheet in total. You could say it was similar to a summary page, but without really summarizing anything as all of the information was collected in that one sheet. I now wish to change the formatting of the document as I need to input...
  8. D

    Grabbing Last Data Entry

    Hi guys, I'm trying to get the last entry of data from my database per person. The database looks a little like this: <tbody> Person Date of Entry A 1/1/2014 B 1/1/2014 A 2/2/2014 B 3/3/2014 </tbody> On a different sheet I want column 2 to look like this: <tbody> A 2/2/2014 B...
  9. S

    Want to make students marksheet with excell

    I want to make students marksheet . The type i want is a excell sheet I am attaching herewith. but this is downloaded and locked . I want to make a sheet just similar to this . Please help me . I cannot fing any option to attach my file (sample) . How can I attach to show my need ?
  10. C

    Drop down list with a different output than input

    Hi all - I am wondering if there is a way to create a dropdown list that outputs a different value than what the input was. For example, I want the dropdown list to contain full words (Machined, Bought, Assembled ect...) and when you click those words, it outputs a code based on the word (M, B...
  11. L

    MACROS - complex operation for summarising lots of sheets into one data base

    Hello, guys. I need to write a code in visual basic for a complex macro, executing the following commands: There is a workbook with approx. 150 sheets, each sheet being a dossier of a firm, so it is needed a table in another sheet (named 'table') to be made that would summarise all the other...
  12. M

    Permenant list of items, accessible by different files

    Bonjour Je fais beaucoup de different fichier excel, mais ils ont toujours la meme base. Est-ce possible de faire un fichier ou une base qui serait toujours en fonction peut-importe le projet sur lequel je travaille. Je fait souvent des "drop down list" avec toujours les memes informations...
  13. A

    Help with customizing userforms

    Hello, I'm new here and have only been using Excel for a short time, I have however taught myself quite a bit about it, but I'm stuck when it comes to macros and codes. Here's my situation, can you help me? I'm trying to create a database to store and sort sports statistics, ie football stats...
  14. M

    Newbie Challenged by Excel Data Entry form

    Hi All, I've only recently started working with Excel VBA, and am still a bit green behind the ears. I'm modifying a spreadsheet Data Entry for sales staff users to enter data via spreadsheet form. The form contains 107 data rows of numeric, string and date/time data. When a user runs the...
  15. Data base- arrange by brand

    Hi, I have a data base of 8200 products, each product has a code of 6 to 7 characters, the 3 first characters tell me the brand of the product. I will like my database separated by brand of product, hopefully a sheet per brand. Each product have 4 columns : code, description, und, price. can a...
  16. S

    Data Base

    I have an excel file called BOQ.xls where i have two sheets Costing & Data in Sheet "Data" 5 Colums are in use A1: Supplier Name, B1: Item code, C1: Item Discription, D1:Cost & E1:Picture of the item. In other sheet "costing" i have two dropdown menu Drop Down1: Supplier Name & 2nd one: Item...
  17. B

    Automatically storing input

    Hi' I have three questions...please help and guide me. 1) Make a sheet (let us call it A) like in a survey - where people fill in different text boxes and thus provide different information. I took a look at VB, but am novice and need a lot of guidance and help. Ideally every submission would...

Some videos you may like

This Week's Hot Topics

Top