Forum Discussion
excel : write in a specific cell
good evening.
how to write data in a specific cell.
given two columns A and B, in A I have the name of the cell where I want to put the content of column B.
thank you.
3 Replies
One option would be a VBA macro.
If you'd rather not use VBA, you can use formulas, but you'd have to enter them in the entire range that could be covered by the cell addresses in column A.
Enter the formula
=XLOOKUP(ADDRESS(ROW(),COLUMN(),4),$A:$A,$B:$B,"")
in all cells of that range.
HansVogelaar thank you very much !
please, suggest something easy (entry level) to read about VBA macro.
I've used macro long time ago but and I believe I need to update my knowledge.
thanks,
antonio
