Hi everyone!
I have an excel spreadsheet with a column of revenue values for every customer to my website. I want to add a column of 0s below these revenue values for every customer that visited the website but did not purchase. Every month the number of visitors who do not purchase will change. Is there a way to automate this process so that if I plug in the number of non-purchasing visitors, excel will auto populate that many zeroes into the revenue column?
I think this will require a macro, but I am unfamiliar with macros. I know I can highlight the number of cells and autofill those cells with 0, but there will be tens of thousands of cells to be autofilled and ideally I would like to transfer this process to someone who is an excel novice. To make the process as simple as possible, inputting the number of non-purchasing visitors into a cell and having the program auto populate the cells with 0s would be best. Thank you!!!
I have an excel spreadsheet with a column of revenue values for every customer to my website. I want to add a column of 0s below these revenue values for every customer that visited the website but did not purchase. Every month the number of visitors who do not purchase will change. Is there a way to automate this process so that if I plug in the number of non-purchasing visitors, excel will auto populate that many zeroes into the revenue column?
I think this will require a macro, but I am unfamiliar with macros. I know I can highlight the number of cells and autofill those cells with 0, but there will be tens of thousands of cells to be autofilled and ideally I would like to transfer this process to someone who is an excel novice. To make the process as simple as possible, inputting the number of non-purchasing visitors into a cell and having the program auto populate the cells with 0s would be best. Thank you!!!