Forum Discussion
Trying to enter the world of VBA and hitting one wall after another... Please Help
In my workbook I have a sheet named "New items for Sellerchamp uploa". Within that sheet is column G with the header titled "Gender" If that column has empty rows i want a Macro that will look at t...
so to clarify I want it to reference the list and search the product names first for boy, and output 1-Male if it is in the title and move on or search for Girl, then, Junior, Women, Men, Unisex etc in that specific order.
I want to use a reference list rather than putting the search values into the code so that I can easily redo the order or add/delete from them if need be.
The ultimate goal is to pre-do some of my classifications for me when i import the data
I want to use a reference list rather than putting the search values into the code so that I can easily redo the order or add/delete from them if need be.
The ultimate goal is to pre-do some of my classifications for me when i import the data
I would recommend Absolute cell referencing to fix. The default would be Relative Reference. But if you want to lock the reference column and row so it does what you want it to do, which is "move on" or "search". Name referencing would fix the issue of range of cells in multiple Workbooks. For example, =D2*J$1 press F4 in invoke absolute referencing, if you press F4, the action will give you the option of Mixed Referencing. But if you want to lock two references then you would want to lock those with Absolute Referencing. I hope this information points you in the right direction. @Modnar1Modnar1
- I will try to google what you have said tomorrow when I am less sleepy, and see if I can make any sense of it but as of right now your speaking a language I do not speak.
