Macro to Transfer Selective Data

Hello,

I need to write a code to accomplish a task in excel but I have almost zero VBA knowledge and I am trying to learn. If anybody could provide some guidance on how I would have to proceed it would be greatly appreciated.

What I am trying to create is the following: I have a database with sales figures for store locations from 2000 - 2020. What I would like to happen is IF the sum of the values in the years (2000-2004) is equal to zero (because the stores had not yet opened), for excel to copy the corresponding store name(located in Column A) and paste it in Column A of a new tab (let's say Sheet2). Moreover, I need this to be such that every time that I run the macro the store names in Column A of Sheet2 get completely replaced by the new names but only for a certain range in the column.


Any assistance would be highly appreciated.

You stated you are trying to learn. Would you like a complete solution or just hints?

Can you redact any sensitive information and post your spreadsheet?

To attach a spreadsheet, click the 'Go Advanced' button below and then use the paperclip in the toolbar to navigate to your document.

So I can't upload the actual spreadsheet, but I created a simpler sample spreadsheet with random names and numbers that basically works in the same way.

So to recap what I would need to happen is: in Sheet1, for each store IF the sum of the values in the years (2000-2004) is equal to zero (because the stores had not yet opened), for excel to copy the corresponding store name(located in Column A ( under "Store Name")) and paste it in Column A of Sheet2 under "Store Name". Moreover, I need this to be such that every time that I run the macro the store names already in Column A of Sheet2 get completely replaced by the list of new names but only for a certain range in the column. The reason I would want it only for a certain range in the column is because I have the TOTAL calculation in the bottom, so I would not want to accidentally erase that.

Once the names are copied into Column A of Sheet 2, I have an INDEX-MATCH setup in Sheet2 that would match the sales figures from Sheet1. So basically I need to transfer the names to serve as an indicator for the INDEX-MATCH.

So if the macro were to work, only the stores: Water, Garage, Telephone, Rockstar, and Hello Kitty would appear in Sheet2 under store names.

Please Login or Register  to view this content.

Glad to help!