anyrandomtech
New Member
- Joined
- Feb 2, 2025
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Looking to do an inventory setup in excel. As of right now I have a row E4: U4 being the data I am trying to copy. E4 is going to be my inventory number. Below is inventory list starting from E10 to E(infinite) is my inventory number. I want E4 to set the inventory number. Lets say 1001, the VBA copies the range F4:U4 and then inserts it down below where the cell has 1001. Or can i have paste the value to the next empty cell of a range? So if E12 :U12 already has date, it would paste the next set of data at E13:U13.
Currently I have my VBA copying the range F4:U4, then inserting it to where a name cell is, you can see it on the green side on the left side. This doesn't work if i mess up and i have to delete the row above it. it will just keep moving it down, unless i delete the renamed cell, and reassign the name to the cell above it.
Currently I have my VBA copying the range F4:U4, then inserting it to where a name cell is, you can see it on the green side on the left side. This doesn't work if i mess up and i have to delete the row above it. it will just keep moving it down, unless i delete the renamed cell, and reassign the name to the cell above it.