Is AutoComplete possible across sheets.

G

G0dsreaper

New Member
Joined
Jan 14, 2021
Messages
6
Office Version
  1. 2016
  2. 2013
Platform
  1. Windows
I am using a workbook as an order form for inventory. I have a macro that copies all the Items that were entered on the order form to a Item Master Sheet. Another Macro then removes any duplicate items. When I fill out a new order form and start typing in the item, I want excel to auto-populate the item name if it is on the Item Master list. Is this possible?
Capture.PNG
Capture 2.PNG
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

R
  • Question
2 column lookup formula to reference new data
Replies
1
Views
168
awoohaw
awoohaw
X
  • Question
VBA code to move data from Pivot Table to unhidden columns on a different sheet?
Replies
0
Views
136
xxbc320xx
X
T
  • Question
vba for index match and return between workbooks
Replies
1
Views
331
GlennUK
G
L
  • Question
Using VBA and monday.com
Replies
2
Views
439
leahmccrary
L
G
  • Solved
Loop with column header match and two conditions paste
Replies
3
Views
425
Legacy 143009
L

Forum statistics

Threads
1,214,849
Messages
6,121,925
Members
449,056
Latest member
denissimo

Share this page

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
Back
Top