Hired WP freelancer to design and needs to use/transfer the design to my website...HELP me please....

There are a few different ways you can go about this...but it's not going to be easy for your first time setting up a site on a web host. Please note that this is a fairly complicated process, and these are just quick lists I've put together to give you an idea of what you'll likely have to do. They're not meant to be exhaustive step-by-step instructions.

Option 1

• Export your existing WordPress table from your testing database to an SQL file.</li>
• Set up a new database and user on your web host.
• Import your SQL file.
• Edit the settings in your new database to match your domain.
• Transfer all of your files into your public_html directory on your web host (either through ftp or by zipping your files and uploading/unzipping them through your host's cpanel).
• Edit the wp-config.php file to establish a connection to your new database.
• Comb through your templates and css files to make sure there are no absolute links to your testing server.
• Activate any necessary plugins.
• Cross your fingers.

Option 2

• Use WordPress's Import/Export tool to export your test site's content.
• Your web host probably has a quick-install option (something like Simple Scripts or Mojo Marketplace) for WordPress...allowing you to quickly and easily create a new WordPress installation at your domain. This will take care of creating the database and editing the wp-config.php file for you. Use it.
• Use WordPress's Import/Export tool to import your site's content.
• Transfer your theme files to the public_html/wp-content/themes directory on your web host (either through ftp or by zipping your files and uploading/unzipping them through your host's cpanel).
• Comb through your templates and css files to make sure there are no absolute links to your testing server.
• Install and activate any necessary plugins.
• Cross your fingers.

Option 3

• Pay your freelancer to do it for you and change your passwords when he/she is done.

In general, Option 1 will work better than Option 2 most of the time, if you're comfortable setting up a database & user. Option 2 will be quite a bit easier, but doesn't always work as well...depending on how the theme is set up. Option 3 will likely save you a lot of time and frustration...but will cost you a few bucks and you won't have the joy of pushing your own site live. Use this option if you need it done right away...then take the time to learn all of the necessary steps at your own pace.

After typing all of this up, I did a quick Google search and found a bit about Moving WordPress to a new host in the WordPress Codex. It's much more detailed. You'll want to follow the steps under the heading Changing Your Domain Name and URLs.

Hope this helps. Good luck!