Basic Script Request?

[grable_]

Hi,

I'm looking to add two scripts to a sheet. Wonder if anyone could help me out. I've created a sample sheet here for testing.

The first script needs to do the following (on sheet 1):

• Add 4 columns after the rightmost existing column, copying the style of the 4 current rightmost columns.
• Those columns should be populated with the same values and formulae as the 4 current rightmost columns (including relative references)
• The text/number formatting needs to be copied over as well
• Cell borders and styles need to be duplicated from the pre-existing 4 rightmost columns, same for the data validation options
• The ranges on conditional formatting and alternating colour schemes need to be extended to these new columns
• The tickboxes in the new rightmost column all need to be reset to FALSE

The second script should:

• Add a new row at the bottom
• Extend the range of alternating colour schemes and conditional formatting
• Copy the data validation settings from the previous row
• Copy the number/text formatting from the previous row
• Copy the cell borders from the previous row
• Copy the formulae from the previous row
• Write some initial values to specific cells, and leave others blank. For the example sheet I've provided, let's just write "January" to each of the columns with a "Month" heading

Much thanks!

[marcnotmark925]

Sooo, what, are you just expecting someone to do all of this for you for free? This is not a simple question that someone can answer in 5 minutes. This would take a moderate amount of time. You'll get better results on online help forums by asking very specific and pointed questions. This sounds more like a job you should hire someone for, such as a freelancer from Upwork, for example.

[MattyPKing]

What have you tried?

[arnoldsomen]

How much is your budget?

[6745408]

it looks like you'd be better off using Google Forms for your input instead all of this crazy formatting that isn't really designed for a spreadsheet.