I need a code that will return a letter in a cell if another cell is occupied.
For example:
If A1:A7 are full I need B1:B7 to contain the letter U.
I need a code that will return a letter in a cell if another cell is occupied.
For example:
If A1:A7 are full I need B1:B7 to contain the letter U.
Hi,
Do you mean if ALL cells in the range A1:A7 are full then ALL cells in the range B1:B7 should contain the letter "U" or for each cell in range A1:A7 that is full, put a "U" in the corresponding cell in column B?
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hi
Try this formula:
=IF(ISBLANK(A1:A7)=FALSE,"U","")
Click *, if my suggestion helps you. Have a good day!!
The formual would work however I can't have formulas in a cell
Do you want a macro?
Yes I need to add it into an existing macro
Just put the formula in the cell and then remove the cell and leave the value using
Please Login or Register to view this content.
I need to run a macro as I have 90 different files with different amounts of data
Check this out...
luke.xlsm
perfect thanks a lot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks