### Similar Threads:

1.Create a new workbook for all Unique values and new work sheets to that new workboks

I'm new to VBA and needs to achieve the following task:
I've got a workbook with one worksheet with more then 1000 rows of
data with 185 columns.
There multiple Territory Reps in column E and one/multiple Retailer on
column B. There are one/multiple retailers for each Territory Rep.
I need to create new workbook for each unique Territory_Rep and one/
multiple worksheets on this new workbook.
Finally I抣l have 5 workbooks for Territory Reps and each workbook
will have multiple worksheets for each Retailer that belongs to the
Territory Rep. Each sheet will have calculated figures that would
derived from column Sales1 and Sales2.
Data looks as bellow:
Category Retailer_No Retailer_Name Status Territory_Rep Sales1
Sales2
Cat1 1 Ret 1 Acti Rep
1 100 300
Cat1 9 Ret 2 Acti Rep
2 300 100
Cat1 7 Ret 3 Acti Rep
1 400 200
Cat1 4 Ret 4 Acti Rep
4 100 100
Cat1 5 Ret 5 Acti Rep
3 200 500
Cat1 10 Ret 10 Acti Rep
3 300 100
Cat1 11 Ret 11 Acti Rep
1 600 200
Cat2 6 Ret 6 Acti Rep
2 800 700
Cat2 2 Ret 7 Acti Rep
5 500 500
Sort the table by Territory Rep as below:
Category Retailer_No Retailer_Name Status Territory_Rep Sales1
Sales2
Cat1 1 Ret 1 Acti Rep
1 100 300
Cat1 7 Ret 3 Acti Rep
1 400 200
Cat1 11 Ret 11 Acti Rep
1 600 200
Cat1 9 Ret 2 Acti Rep
2 300 100
Cat2 6 Ret 6 Acti Rep
2 800 700
Cat1 5 Ret 5 Acti Rep
3 200 500
Cat1 10 Ret 10 Acti Rep
3 300 100
Cat1 4 Ret 4 Acti Rep
4 100 100
Cat2 2 Ret 7 Acti Rep
5 500 500
Then create:
Workbook "Rep 1 13-02-2008.xls"
Worksheets "Ret 1", "Ret 3", and "Ret 11"
On each sheet insert a calculated value from the main sheet
e.g. Sales1 + Sales2
Workbook "Rep 2 13-02-2008.xls"
Worksheets "Ret 2" and "Ret 6"
Workbook "Rep 3 13-02-2008.xls"
Create Worksheets named: "Ret 5" and "Ret 10"
Workbook 4 = "Rep 4 13-02-2008.xls"
Worksheets named: "Ret 4" and "Ret 8"
Workbook 5 = "Rep 3 13-02-2008.xls"
Worksheet named: "Ret 7"
Nazmul
Thanks in advance

2.vlookup:suddenly doesn't work for half the rows in the same wk.bk

I have a vlookup retrieving info from another page in the same workbook. To
make things easy I copy the first row of formulas to the rows below and it
works up to a ceratin row, and the I get #N/A. The error description is
"Inconsistent formula" and the trace has a line from the lookup value to the
cell next to it and then a dotted line to another cell two rows up.
I have no clue why there is this difference - I have changed cell formats
both on the source page and in my report page; the formula is the same as the
rows above (they work, btw) so what is the problem with the rest of the rows?
Any comments or suggestions?

3.vlookup:suddenly doesn't work for half the rows in the same wk

Hi,
You're right I haven't used absolutes.
I have a source page with information for a project within the same row (to
the right of the project number). Then the range of the whole sheet is named
Calculatie.
So the formula on the report sheet is
=if(A3=0;"";VLOOKUP(A3;calculatie;3;false))
This formula is the same for each cell below including the one containing
#N/A except of course the lookup value is different because it is a new row.
I considered the fact that the problem info may fall outside of the named
range, but I renamed it and re-enterd the VLOOKUP formula and still no joy.
So, any ideas?
Rochelle
"Niek Otten" wrote:
> Please post your initial formula and the first one giving #NA.
> I guess that the reference to the table is relative instead of absolute,
> something like A1:A100 instead of $A$1:$A$100.
>
> --
> Kind regards,
>
> Niek Otten
>
> "Rochelle" < XXXX@XXXXX.COM > wrote in message
> news: XXXX@XXXXX.COM ...
> >I have a vlookup retrieving info from another page in the same workbook. To
> > make things easy I copy the first row of formulas to the rows below and it
> > works up to a ceratin row, and the I get #N/A. The error description is
> > "Inconsistent formula" and the trace has a line from the lookup value to
> > the
> > cell next to it and then a dotted line to another cell two rows up.
> > I have no clue why there is this difference - I have changed cell formats
> > both on the source page and in my report page; the formula is the same as
> > the
> > rows above (they work, btw) so what is the problem with the rest of the
> > rows?
> > Any comments or suggestions?
>
>
>

4.vlookup doesn't work consistently (I think), kindly help

I am using VLOOKUP() to pull out a column value from a range of data. Here is
the problem:
When I use this fn on the same page as the referenced range, it works fine.
For example,
=VLOOKUP(L2,A2:I18,5) looks up the value in L2, finds it in the first column
and returns the 5th column data... BUT
=VLOOKUP(G6,'Master Prep List'!A2:I18,5) where G6 represents a value found
in the same range on a different worksheet, here Master Prep List, returns
#N/A.
This does not seem correct to me, unless I am not using the fn correctly,
which is always a possibility. I am using Excel 2007,
Any help/insight would be appreciated.

5.vlookup doesn't work

I am unable to do a vlookup between different workbooks. I does however work
within the same workbook. Is their something I need to do to turn this
functionality on.
--
Thanks
Michelle

6. vlookup doesn't always work in this situation

7. Error trapping for VLOOKUP...doesn't work so help!

8. Vlookup doesn't work until i edit(but not change) the lookup cell