importing data from tabs

jkernaghan

New Member
Joined
May 4, 2012
Messages
1
Hello all,
This my my first time using a forum like this so bear with me please.
I'm working on a spread sheet to track inventories and sales. I'd like to auto populate new tabls with information from exsisting tabs, ie. product names, formulas and final inventory figures. Is there an easys way to do this or will I need to write a macro. Also I've never written a macro so if one is needed any help on getting started on that would be great! Thanks very much for the help!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

JLGWhiz

Well-known Member
Joined
Feb 7, 2012
Messages
12,979
Office Version
  1. 2013
Platform
  1. Windows
Hello all,
This my my first time using a forum like this so bear with me please.
I'm working on a spread sheet to track inventories and sales. I'd like to auto populate new tabls with information from exsisting tabs, ie. product names, formulas and final inventory figures. Is there an easys way to do this or will I need to write a macro. Also I've never written a macro so if one is needed any help on getting started on that would be great! Thanks very much for the help!


Hi jkernaghan, welcome aboard. There is an abundance of information available in the Forum website. The FAQ and Community segments offer information that covers all types of subjects concerning Excel and VBA. You can also browse the different threads in the forum to see how problems are presented and solutions are provided. It is best to read the articles providee by the site moderator which give directions on how to post your questions using screen shots and even shared servers. We are all volunteers on the forum and while some are professional, most are just ordinary users who happen to have some expertise in areas they respond to. But none of us are mind readers and we cannot see your work documents, so when you post, be sure to include enough information so an analysis of your problem can be made and a solution offered.
 

Smitty

Legend
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

If you follow the HTML Maker link in my sig you'll be able to post shots of your sheet(s).

In the meantime, you might want to take a look at VLOOKUP in the helpfile. And there's a tutorial here. You'll also find an article there about getting started with the Macro Recorder.

HTH,
 

Watch MrExcel Video

Forum statistics

Threads
1,133,814
Messages
5,661,052
Members
418,612
Latest member
iihtsurat5

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