I’m trying to create a simple macro where the user can batch edit cells by entering a reference number.
Here is the idea. Suppose I want to track shipments for different items on my inventory. There are 4 columns on my spreadsheet (Item#, Product Description, Order Date, Delivery Date) and hundreds of rows. All this data is on sheet1. On sheet2, I had set up the action panel, where the user can input the item#, select which action to fill in (order date or delivery date) and input the date.
While I record the macro, I am having trouble with getting to the destination cell where I want the information to be automatically be filled in. For example, suppose I want to fill in the delivery date for item 235. How do I tell excel to go to that cell? (Column of Delivery Date, Row of Item 235). Given that I want batch record cells, how do I repeat the above for every item?
IMPORTANT NOTE: I am a beginner when it comes to Macros and I barely understand VBA code. So please don’t involve code language.
Here is the idea. Suppose I want to track shipments for different items on my inventory. There are 4 columns on my spreadsheet (Item#, Product Description, Order Date, Delivery Date) and hundreds of rows. All this data is on sheet1. On sheet2, I had set up the action panel, where the user can input the item#, select which action to fill in (order date or delivery date) and input the date.
While I record the macro, I am having trouble with getting to the destination cell where I want the information to be automatically be filled in. For example, suppose I want to fill in the delivery date for item 235. How do I tell excel to go to that cell? (Column of Delivery Date, Row of Item 235). Given that I want batch record cells, how do I repeat the above for every item?
IMPORTANT NOTE: I am a beginner when it comes to Macros and I barely understand VBA code. So please don’t involve code language.
