Spreadsheet Log

MsWiz

New Member
Joined
Oct 19, 2005
Messages
21
Hello everyone. I have a spreadsheet in Excel that is for a receiving report for a warehouse. In cell K2 it has an automatic numbering code which is the following:

Private Sub Workbook_Open()
Dim x As Range
Set x = Sheets("Receiving Report").Range("k2")
If IsNull(x) Then
x = 1
Else: x.Value = x.Value + 1
End If
End Sub

1. What I need now is a code that on Sheet 2 - Named "Receiving Report Log" which automatically starts at A5 and puts in the first report number which is cell K2 on the Receiving report

2. Line B5 needs to reflect the name of the project which comes from line B4 on the Receiving report.

3. Line C5 needs to reflect the date which is on line I2

4. Line D5 needs to reflect the vendor name from line I3

5. Line E5 needs to reflect the PO number from line J6

6. Line F5 needs to reflect the Item description from lines A10 - A-19 but only show if they are filled out.

Everytime they open the spreadsheet (template) and it makes a new number, it needs to reflect this on the Log.

Can this be done with code? If so, any help would be wonderful.

Thanks in advance for your help.

Let me know if I need to give you anymore information.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,990
Messages
5,834,761
Members
430,318
Latest member
ZackChua95

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