Creating an Order Reference Table

EvanM

New Member
Joined
Mar 23, 2018
Messages
1
Good Morning,

OS: Windows 7
System Type: 64 Bit
Excel Version: Office Pro Plus 2013

I am currently working on a workbook that allows users to enter in data regarding the calls that they take. It has been asked if additional fields can be added for orders that may be placed on some calls. They could be added but this would make the sheet rows very long and data entry very bulky. The plan is to try to create a separate tab in the same workbook with a table for orders that can reference back to the main table. So when you are working in the Call Log, you enter any value in Column C and this creates a New Record in the Order Log connecting the two with a single Index. Here is pretty much what I have so far:

Call Log

Index
Date
Create Order
Contact
Notes
0001
03/25/2018
Jeff
Update
0002
03/25/2018
Y
Tom
Order Made
0003
03/25/2018
Zack
Update

<tbody>
</tbody>

<tbody>
</tbody>

Order Log

Order #
Date
Contact
Phone
Notes
Index
MAR0002
03/25/2018
555-555-5555
Order Made
0002
MAR0005
03/25/2018
555-555-1234
Order Made
0005
MAR0010
03/25/2018
555-555-5678
Order Made
0010

<tbody>
</tbody>

<tbody>
</tbody>

There is typically never more than one order per call, and if there was it is usually added as a separate line in the Call Log. I am pretty sure I may need to add an additional column to the Call Log to reference the Order #. I currently do not have any VBA code written to attempt this yet. I am just having a hard time figuring out how:

- When entering data in the Call Log, for a call that requires an order, add any value to Column B (where B <> "")
- You change view to the Order Log table, and a New Row is added
- An Order # is created based off of the Index you are creating the order for
- Common Fields such as Name, Notes, etc are automatically copied from one table to the other

Both tables would start in cell B2 to allow for padding and an area around the tables to add various items such as buttons and stats.
I hope I have provided enough information to get a footing on what I am requesting. Please let me know if this is possible or if there are any questions regarding this.

Kind Regards,

EvanM
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Forum statistics

Threads
1,136,435
Messages
5,675,848
Members
419,586
Latest member
RoteichA

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