Program to Auto-Update/Copy Data in OpenOffice Spreadsheets

This project was awarded to gshiels for $250 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
Project Description

I am looking for someone to write a macro/program for an OpenOffice Spreadsheet. The purpose of the macro is to copy data within the spreadsheet, and update data in different fields when new data is added. The macro must be able to run automatically when new data is added, and when it runs, it must automatically save the resulting spreadsheet into a specified directory on the local computer.


-->The spreadsheet, "[url removed, login to view]" will be in excel, but it will be opened by the user in Open Office. The data the is being updated will appear as a spreadsheet in Excel format, but then the user will open the excel spreadsheet in OpenOffice. Please see attached file for a sample!

--> The spreadsheet contains 4 columns of data (A-D) and as many as a million records (rows). Each cell in this range ([url removed, login to view],999) contains a blank or value. The first row (5) is the header row). The first column (A) contains a date xx/xx/xxxx.

--> No single month is expected to have more than 30,000 rows.

--> The macro should run automatically when new records are added (imported) to Columns A-D in the workbook.

Once the macro runs, it saves the spreadsheet to a folder of our choosing. This folder is to be set through a “settings” window, so that in each installation it can be set differently.

Instructions (partial):

If cell G4 is blank, copy columns B-D of those records having dates of 01/xx/2010 in Column A to the range E6-G29,999 and copy the date (01/xx/2010) of the last of those records into cell G4, if cell G4 contains a date 01/xx/2010 , b) copy columns B-D of those records having dates of 02/xx/2010 in Column A to the range E6-G29,999 and copy the date (02/xx/2010) of the last of those records into cell G4, and so on.

Once a set of records has been copied to range [url removed, login to view],999, the row of formulas and values in range [url removed, login to view] should then be copied to cells [url removed, login to view],999.

Next, the formulas in cells P30008 –P30014. P30017-P30023, P30026-P30034 should be copied to:

cells F30008 –F30014. F30017-F30023, F30026-F30034 ) if G4 = 01/xx/2010,

cells G300078–G30014. G30017-G30023, G30026-G30034 if G4=01/xx/2011, and so on through cells O30008-O30014, O30017-O30023,O30026-O30034 if G4=01/xx/2019

The formulas in cells P30037 –P30043. P30046-P30052, P30055-P300363 should be copied to:

cells F30037-F30043, F30046-F30052, F30055-F30063 if G4 = 02/xx/2010,

cells F30066-F30072, F30075-F30081, F30084-F30092 if G4=02/xx/2010, and so on through

cells F30327-F30333, F30336-30342, F30345-F30353 if G4=12/xx/2010

The formulas in cells P30385-P30391, P30394-P30400,P30343-P303411 ) should be copied to:

cells F30385-F30391, F30394-F30400,F30343-F303411 if G4=02/xx/2010,

cells G30385-G30391, G30394-G30400,G30343-G303411 if G4=02/xx/2011 and so on through

cells O30385-O30391, O30394-O30400,O30343-O303411 if G4=02/xx/2011G4 = 02/xx/2019,

The formulas in cells P0414-P30420, P30423-P30429, P30432-P30440 should be copied to: cells F0414-F30420, F30423-F30429, F30432-F30440 if G4 = 03/xx/2010,

The formulas in cells P30443-P30449, P30452-P30458, P30461-P30469 should be copied to: cells P30443-P30449, P30452-P30458, P30461-P30469 if G4=04/xx/2010, and so on through

The formulas in cells P30675-P30681, P30684-P30690, P30693-P307001copied to : cells

F30675-F30681, F30684-F30690, F30693-F30701 if G4=12/xx/2010

The formulas:

In cells AB30008-AB30010 Should be copied to: R30385-AA30387, R30414-AA30416, R30443-AA30445,R30472-AA30474, R30501-AA30503, R30530-AA30532, R30559-AA30561, R30588-AA30590, R30617-AA30619, R30646-AA30648, R30675-AA30677

In cells AB30012-AB30013 should be copied to R30389-AA30390, R30418-AA30419, R30447-AA30448, R30476-AA30477, R30505-AA30506, R30534-AA30535, R30563-AA30564, R30592-AA30593, R30621-AA30622, R30650-AA30651, R30679-AA30680

[some instructions to be discussed]

Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online