Completed

Code/script for inserting cells into data range

I have an excel spreadsheet with weekly measurements of gas. I need to be able to insert blank cells into the sheet (in between weekly sampling) to represent daily measurements. The problem is that the sampling dates are not at regular intervals. i.e. its not just a case of adding in 6 blank cells between weekly measurement dates. I can use SPSS if it is easier to write a syntax for SPSS to complete this function?

Skills: Excel, SPSS Statistics, Statistics, Data Processing, Visual Basic

See more: write code transfer data sql server excel, generate data based columns excel visual basic script, script cut paste data website excel, get active cell google script, google apps script write array to spreadsheet, google script push, google sheet range, google script clear range, google script insert row, getnextdatacell, google script isblank, excel script copy cell data closed file, fill blank cells data vba excel, code read web page data transfer excel, write script macro copy data website excel, fill cells data excel macro, adding find text function excel script, excel vba script merge cells, code cut pasting cells excel vba, script import text data excel

About the Employer:
( 2 reviews ) Brisbane, Australia

Project ID: #22192865

Awarded to:

kamalnathanj

hello Understood the outline idea of that need extract most common words/phrases from database .But I would like to discuss with you to understand more on your specification requirements to prepare the detailed propos More

$20 AUD in 7 days
(0 Reviews)
0.0

7 freelancers are bidding on average $74 for this job

schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$120 AUD in 4 days
(340 Reviews)
8.0
ksriniravi

Greetings! I have reviewed the attachment. I can write a macro to insert as many rows as required between 2 successive rows depending on the dates in the 2 rows. Being a full time freelancer working exclusively on Ex More

$20 AUD in 1 day
(198 Reviews)
6.9
writingapp

Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL More

$30 AUD in 1 day
(20 Reviews)
4.6
wwwTom

Greetings. Thanks for this opportunity. I am a preferred VB program developer with over 6 years experience and a strong workforce of many Professionals. I'm interested in working with you. As per your interest, I can More

$200 AUD in 2 days
(1 Review)
3.6
IshaqKN

Hi there, Yes I will do; no problem if data is not at regular intervals, I will add logic to script. I am expert in data processing + regex. I am doing it with Python. Best regards, Ishaq Relevant Skills and Experie More

$25 AUD in 3 days
(2 Reviews)
2.1
primerkazi

hi! so...i've gone through the project details and the xlsx file...and i have a few quesitons... # when do you need to insert a blank row (i guess, it's the rows to insert)? at some specific day of the week...like at More

$100 AUD in 2 days
(0 Reviews)
0.0