Autofill values in specific column

**ks100** · 12-18-2013, 03:55 PM

Looking to do:

Is text "unit" in file name?

If yes then perform following tasks:

1. Look for cell containing text "location".
2. Change the cell value to "1" for cells in the following range: From the cell immeadietly below the "location" cell, all the way until the last row with data in ANY column on the spreadsheet.

Very important to note that the cell with value: "location" could be anywhere in the spreadsheet. I attached a sample with one possible example of where the cell could be, and how I need the script to adapt to it.

Spreadsheet has before and after example.

**ks100** · 12-18-2013, 04:48 PM

If it helps at all, the "location" cell would probably never be lower than row 20, however horizontally it could end up anywhere.

**jindon** · 12-18-2013, 05:47 PM

Does this help?

Please Login or Register  to view this content.

**ks100** · 12-19-2013, 11:14 AM

Originally Posted by jindon

Does this help?

Please Login or Register  to view this content.

Yes it did, thank you, excellent work.

**ks100** · 12-19-2013, 04:25 PM

Originally Posted by jindon

Does this help?

Please Login or Register  to view this content.

Actually, one more thing. Is there a way to have it automatically skip a row before filling in the data? So basically leave one blank cell below the "location" cell and the rest of the column?

**jindon** · 12-19-2013, 06:44 PM

Do you mean like this?

Please Login or Register  to view this content.

Autofill values in specific column

LinkBack

Thread Tools

Rate This Thread

Display

Autofill values in specific column

Re: If (text) contained in file name, then perform following checks:

Re: If (text) contained in file name, then perform following checks:

Re: If (text) contained in file name, then perform following checks:

Re: If (text) contained in file name, then perform following checks:

Re: Autofill values in specific column

Thread Information

Users Browsing this Thread

Similar Threads

VBA code to perform mail merge using text file

[SOLVED] Need to perform some checks with letters in text

[SOLVED] Create variables, perform replace, then write text file.

[SOLVED] Formula which checks whether a string is found in a range and checks 2 criteria

When I import a csv file text that contained a + gets scrambled

Bookmarks

Bookmarks

Posting Permissions