Hi,
I have two range of cells with values linked to another workbook. There are two 'SUM' formula at the end of each range of values. All these were presented in one column. Is there any way for me to copy the whole column and paste as values in another column but still keep the 'SUM" function. (instead of copying the linked cell, paste as values in another column and drag/type the 'SUM' function again at the new column)
For e.g. Referring to the image below, I want to copy column B and paste as values in column C but still keep the 'SUM' function in row 15 and 20.
Screenshot 2021-04-20 135804.jpg
Thanks
Bookmarks