In Progress

Program to Auto-Update/Copy Data in OpenOffice Spreadsheets

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.

Notes:

-->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]

Skills: Accounting, Excel, Microsoft, Visual Basic, Windows Desktop

See more: openoffice spreadsheet fields update, write and copy, program of computer, copy date openoffice macro, program for computer, xlsx, spreadsheets, some program, run and update, row b, open data, office macro, data visual, data in, d in i, d auto, copy excel, copy data, auto update, computer program, data range, write macro, excel macro row, program sample, sample visual basic excel

About the Employer:
( 5 reviews ) San Francisco, United States

Project ID: #1126785

Awarded to:

gshiels

Please see PM

$250 USD in 2 days
(12 Reviews)
5.1

7 freelancers are bidding on average $134 for this job

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$200 USD in 5 days
(64 Reviews)
6.5
mrbrave

See PMB details.

$120 USD in 3 days
(67 Reviews)
5.3
binaryromel

########## Experienced! Please check PM. ##########

$100 USD in 3 days
(36 Reviews)
5.0
dasmoeh

Hi, i can do this for you.

$100 USD in 2 days
(5 Reviews)
4.2
infodukeinfosys

having wide experience and wide knowledge with an ISO 9001:2008 certified company and already done it,also provide demo cause our school management system implemented more then 500 school in India and integrated with l More

$140 USD in 4 days
(0 Reviews)
0.0
justinjoseph

sir, I can do this.

$30 USD in 2 days
(0 Reviews)
0.0