+ Reply to Thread
Results 1 to 1 of 1

Cannot get correct data from database

  1. #1
    Registered User
    Join Date
    03-21-2015
    Location
    Latvia
    MS-Off Ver
    2014
    Posts
    1

    Cannot get correct data from database

    1. Problem ONE
    I have database, Sheet "Data page"
    Pilnekrāna tveršana 2015.03.23. 80702.bmp.jpg

    In sheet "Work page" I paste code number in column 3 and quantity of work in column 11, then excel with formula fills automatically columns 4, 5, 6, 7, 8, 9, 10, 12, 13, 14
    Pilnekrāna tveršana 2015.03.23. 82304.bmp.jpg

    I use this king of formula: =INDEX('Data page'!$A$1:$K$10007;MATCH($E11;'Data page'!$A$1:$A$10007;0);MATCH('Data page'!$B$1;'Data page'!$A$1:$I$1;0))

    BUT I have problem with percentage in column 12 and 13, formula takes only first row of percentage, but I need it to takes percentage depending of calculated quantity in column 11. If changing quantity, then changing also percentage in column 12 an 13 for each code (column 3) different.

    Have can I do it?

    2. Problem TWO

    I want to make column 2 in sheet "Work page" with drop down list like, when I choose in drop down list text, after selecting in cell it shows only number for this text.
    And is it possible, when click on drop down list, it is opening wider than cells width, so you can see all text width in drop down list, without changing cells widht?

    Apologizing for my english!

    Also attached my example of my excel file.



    Please help me!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Check cells are correct format and contain correct data
    By rikosborne in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-26-2014, 02:53 PM
  2. Replies: 4
    Last Post: 03-21-2013, 11:35 AM
  3. Fix Needed for Code to Send Correct Data to Correct Sheets
    By swordswinger710 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-04-2012, 03:53 PM
  4. Importing Text (csv) table to correct database
    By climoc in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2011, 01:17 PM
  5. Importing csv to correct database
    By climoc in forum Access Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2011, 11:33 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1