|I have to review these files and do not enter the data. And the two files are made by different sources and people |
Data validation is a tool that helps you control the kind of information that is entered in your worksheet.
Talk to the two sources that create the files and have them institute some type of data validation scheme.
Point out the it will save time & money.
How is your file setup, post an example with Column Letters & Headers
and row numbers.
READ THIS FIRST ON HOW TO POST:
As it stands, there are a number of different ways to input:
john simpson transport
J. simpson, Transport
Simpson, J. Transport
Simpson, John, Transport
John Simpson, Transport
Is this all one cell or in two adjacent cells?