How To Update Single Cell, Not All

**ajocius** · 12-30-2007, 01:29 PM

Group,

I'm using Excel 2003 on a machine running Win XP Home. In a column I have the following in each cell down following I18 :

=IF(ISBLANK(I18),"",NOW())

In column J at row 18 I scan a barcode. Each time I scan the barcode and enter the data into my spreadsheet all the cells with the above If statement change at the same time. I just want the row that I send my scanned data to change its time. Why are all of the rows changing and how do I fix this annoying problem.

**shg** · 12-30-2007, 01:40 PM

You would need a deliberate circular reference and set Excel for one iteration.

Better would be to use VBA and the worksheet change event. If you explain a little more what you're doing (or post the workbook), I'll give you an example.

**ajocius** · 12-30-2007, 01:59 PM

See attached spreadsheet. Place anything in column J and everything changes at the same time.

**shg** · 12-30-2007, 02:12 PM

Place anything in column J and everything changes at the same time.

I assume you mean column I. Anyway, that's the way Excel works.

Try this in the ThisWorkbook module:

Please Login or Register  to view this content.

**VBA Noob** · 12-30-2007, 02:59 PM

If you don't need to update all the cells at once and want to keep the general format you could try this

Please Login or Register  to view this content.

VBA Noob

**ajocius** · 12-30-2007, 03:11 PM

Column I inputs continue to change all of column B. See attached. Am I doing something wrong in the module?

**VBA Noob** · 12-30-2007, 03:13 PM

Remove the code from ThisWorkbook and then place in sheet Name Macro88.

http://www.contextures.com/xlvba01.html#Worksheet

VBA Noob

**ajocius** · 12-30-2007, 03:41 PM

It worked. I guess I don't understand how it works, but I'm functional. Thanks to you and shg I'm rolling. Both of you have a nice holiday.

**shg** · 12-30-2007, 05:17 PM

Originally Posted by Noob

Remove the code from ThisWorkbook and then place in sheet Name Macro88.

My mistake, thanks Noob.

**caryfloric** · 07-03-2014, 12:23 AM

Originally Posted by ajocius

Group,

I'm using Excel 2003 on a machine running Win XP Home. In a column I have the following in each cell down following I18 :

=IF(ISBLANK(I18),"",NOW())

In column J at row 18 I scan a barcode. Each time I scan the barcode and enter the data into my spreadsheet all the cells with the above If statement change at the same time. I just want the row that I send my scanned data to change its time. Why are all of the rows changing and how do I fix this annoying problem.

So do you know how to update multiple cells which are not connected?????

Ah, I forgot to see the date, again! Ok, just forgive me for one more time, please!!

**FDibbins** · 07-03-2014, 12:25 AM

hi caryfloric and welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Also, this threads is almost 7 years old, I doubt it is still being monitored