Display the value in a given row of the active column

[thatmasonkid]

I have built a distribution database that is basically an order entry sheet and a packing list with a lot of unique features for my business.
What I'd like to do to is to be able to click a report button to generate my packing list instead of re-entering data. To achieve this, I need to be able to pull the data from Row 7 of the active column. I've been trying with the limited knowledge I have of VBA, and searching for forums for anything that could help me to no avail.
Further to that, I will be creating a button that opens my packing slip sheet, and places that data into cell j7. This will auto update the packing list using my existing code. I think I can work that part out, but I sure wouldn't turn away any suggestions for that either
I would greatly appreciate any help with this.
Thanks,
Thatmasonkid

 

[Smitty]

Welcome to the Board!

You can populate a cell with that information like this:

Sheets("Packing List").Range("J7").Value = Cells(7, ActiveCell.Column).Value

For updating the rest, you might want to look into using VLOOKUP.

Hope that helps,

 

[thatmasonkid]

Thanks for the quick reply, I'm not having any luck just yet (i'm now getting errors in some of my code)
I'm going to take some time to play with it and see what I get.
If I can't get anywhere, I'll post again with more detail on my errors.
Thanks again

 

[Smitty]

Feel free to post your code, but make sure to indicate where you're getting the errors.

Someone will be sure to fix it up for you.

 

[thatmasonkid]

Thanks for your help, I was able to solve it after a good nights sleep. My problem was that I had the Packing List sheet protected, and I had forgotten to build in an unprotect/protect command to perform the action.