Using data to complete a form

[-emma-]

Hi all,

I'm sure I’ve asked this before but cannot seem to find it anywhere.

I have various bits of detail, however, what I am after seems relatively easy.

Tab 1
Row 1 consists of the date
Column A consists of business name
B2 – G23 holds number of orders each day from each company.

Tab 2
Holds a standard template which has space for Date (which I want to take from Row 1), Business Name (Which I want to take from column A) and number of orders (which will be pulled from B2 – G23).

B2 – G23 does not always contain a number (for example, some days we may receive no orders at all).

I need a way for the information to be pulled from Tab 1 into Tab 2. Maybe building a macro button at the end of each cell between B2 – G23 which once this is pressed, it pulls the date, business name and order number into Tab 2.

Any help on this would be welcomed.

Thanks

Emma

 

[igold]

Hi -emma-,

Does every business name get pulled over to tab 2 and do you want the sum of the orders or do you want them broken out by date. Also, perhaps a little better idea of what the two sheets look like...

igold