A macro to auto fill in text depending upon cell content

Hi Guys,
I am hoping for a little (lot) of help please.
I have created a workbook to help keep track of work. It is working great but time consuming entering a lot of text. I would like to use a macro to help with text entry.

I would like when I enter N in column G then columns H,I,J,K,L,M,N,O,P,Q,R all become N/A
I would like when I enter N in column S then columns T,U,V,W all become N/A
I would like when I enter N in column Y then columns Z,AA,AB,AC,AD,AE,AF,AG all become N/A
I would like when I enter N in column AI then columns AJ,AK,AL all become N/A
I would like when I enter N in column AM then columns AN,AO,AP,AQ,AR all become N/A
I would like when I enter N in column AS then column AT becomes N/A

I have attached a copy of workbook with line 2 filled in is an example.


Thanks a lot in advance.

***** this workbook will possibly reach 1000+ job numbers in future*****

Thanks again

Try adding this code into Sheet1. I've added in code to go to the next empty cell, you can remove them if not needed.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

How to install your new code

1. Copy the Excel VBA code from the forum post.
2. Select the workbook in which you want to store the Excel VBA code:
3. Right click the tab you want the macro in
   This opens the Visual Basic Editor; the cursor will be blinking in the code pane.
4. Edit > Paste the macro into the code pane.
5. Close the VBEditor
6. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

Since this is a worksheet change event macro it wil run every time a change is made in that sheet.