Results 1 to 11 of 11

Create a list for specfied person from long list

Threaded View

Jayess Create a list for specfied... 05-07-2013, 08:37 AM
AB33 Re: Create a list for... 05-07-2013, 09:07 AM
Jayess Re: Create a list for... 05-07-2013, 09:44 AM
Jayess Re: Create a list for... 05-07-2013, 10:56 AM
Jayess Re: Create a list for... 05-07-2013, 11:15 AM
AB33 Re: Create a list for... 05-07-2013, 11:36 AM
Jayess Re: Create a list for... 05-07-2013, 11:46 AM
AB33 Re: Create a list for... 05-07-2013, 11:55 AM
Jayess Re: Create a list for... 05-07-2013, 05:54 PM
AB33 Re: Create a list for... 05-07-2013, 06:16 PM
AB33 Re: Create a list for... 05-08-2013, 06:15 AM
  1. #9
    Registered User
    Join Date
    04-16-2013
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Create a list for specfied person from long list

    Build Manager Instructions Template.xlsxHi,

    Thanks for explaining things to me, appreciate it. I dont completely understand, but i see where your going. I have a few questions. I the report i create comes from a master data dump of raw data that has almost 340 columns, i look up the columns i need and just paste the raw data sheet into the raw data (MonoFullDataExtract). see attached it will make more sense.
    My question is, can i still pull in this spreadsheet to refresh the data using my look up's?
    How do i run the the code in the previuos sheet. is it the visial basic coding? I have never really used that and write all my formulas within cells on my spreadsheets. i am a fast learner, but fear i may be out of my depth a little.

    The purpose of the spreadsheet is for our build managers to be able to amend the dates in the sheet, they will highlight the cells they have changed, then an administrator will check the spreadsheet for all the highlighted/updated cells and update the database manually. The only way i can gain the data back from the database is by downloading the raw data and manipulating the data as attached.

    The raw data contains just shout of 3000 lines but is growing all the time, it will reach over 20,000 in the next couple of years. The columns do not change and shouldn't in the short to long term. I have to run this report at leats once a day as and when the database is updated.

    I had to delete a lot of lines and formatting due to the size of the sheet.

    Thanks again, for all your help
    Last edited by Jayess; 05-07-2013 at 05:58 PM.

Thread Information

Users Browsing this Thread

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

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