Buying VB for Excel Coding

Discussion in 'Programming' started by Rui, Dec 3, 2010.

  1. #1
    Hello,

    I'm looking for someone that can code VB for excel and can help me out with the specifications below. If you think you can do this, please send me your cost and timeline.


    Workbook A

    - This workbook is considered the Template. The headers within this template are static and always remain the same.

    - Some of the values that will be pasted into this Workbook will be "SUMS", so the actual result would have to be pasted and not the equation.

    - A new column has to be created for every Workbook that is scraped. (i.e. - Column 4 = Workbook B, Column 5 = Workbook C, Column 6 = Workbook D, and so on.)

    - Fields that are pasted into Workbook A would have to be mapped based on the row number.(i.e. - When pulling data from Workbook B, the values might be inserted into Workbook A in the following order; B4, B7, B12, B43, etc.) Each value would have to be mapped based on the row #.

    Optional but ideal - I would like the script to pull specific fields from specific files based on keywords in the Workbook filenames.

    -- i.e. - If Workbook B is titled "WorkbookB_Data" then scrape specific values and paste them in specific spots within Workbook A. Any other files that contain the keyword "_Data" would follow the same pattern. If Workbook C is titled "WorkbookC_Info" then scrape defined values and paste them in other specific spots that are noted.


    Workbook B, C, D, E

    - These are the Files that contain the data that I want to insert into Workbook A.

    -- The Data I need to insert will be coming from two (2) worksheets within each file.
     
    Rui, Dec 3, 2010 IP