Overriding a cell value?

NoSparks · #1 04-02-2017, 09:45 PM

Inv_override is name of cell B17

Can you put into words what you want to happen if B17 has something in it ?

ps: go into the Auto_Open module and uncomment Application.ScreeenUpdating = False
so the file will open quicker.

Cyberseeker · #2 04-02-2017, 10:36 PM

Quote:

Originally Posted by NoSparks

Inv_override is name of cell B17
Can you put into words what you want to happen if B17 has something in it ?

ps: go into the Auto_Open module and uncomment Application.ScreenUpdating = False
so the file will open quicker.

Ive fixed the comment error, unprotected the 'order' sheet, and uploaded my attachment again. Please click 'View Group Records' button (c1) repeatedly and notice how the records from the other sheet are deposited in column 'B'.

An invoice number is automatically deposited in B16. However, I have had times when I have wanted to change this. So, I manually type the correct number in B17. It is supposed to override B16.

Post and package is similar, but it works in that case.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow	FUGMAN	Excel Programming	7	02-05-2017 08:37 AM
If value of cell A Matches a value in a Range of cells (column) then add value of cell A to cell C	rick10r	Excel	1	07-05-2016 12:07 PM
Data validation,force cell to be filed with number if respective cell is not empty	nicholes	Excel Programming	0	08-01-2015 09:08 AM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM