Hi,
Minor issue - as you are assigning formulas to ranges it's betrter to do it as a formula not a value, like:
MAjor - the code as you and JustinOz20 presented shall basically
fill all the other columns (A:B & D:J) with some data but only as long as the value under Col C is not empty.
as you mentioned in the first post.
But then you describe
ends up
pasting over the lastrow of data, instead of adding values to the
Sure, these are different words but with quite similar (at least for non-native) meaning.
If you want to add something to current value in a cell use constructions similar to:
or if the content is a number and you want to add
or insert previous content in formula (say its numerical value)
etc.
The hint in yellow banner near the top of the page (best if there are "before" and "afer" situations presented) is very useful
edit: seems it's not clear also for native (well, I know this 2 versions of language are quite different, but anyway)
Bookmarks