Display the value in a given row of the active column

thatmasonkid

New Member
Joined
Apr 14, 2009
Messages
6
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
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Apr 14, 2009
Messages
6
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

Legend
Joined
May 15, 2003
Messages
29,536
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

New Member
Joined
Apr 14, 2009
Messages
6
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,129,478
Messages
5,636,567
Members
416,924
Latest member
cmlacerna

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top