specific rows

Hi, I am trying to sort some data, if I indicate header:=xlyes it only exclude the first row. However, I need the first 2 row to be excluded from sorting as I have the first 2 rows as header for my table. Does anyone knows how i can exclude the first 2 row when sorting my data using VBA? if it...

Sheet A <tbody> A B C 1 Name Policy Amount 2 Paul 234 50 3 Paul 234 100 4 Sharon 365 20 5 sharon 365 40 6 shane 976 100 7 andrea 573 30 8 andrea 573 30 9 andrea 573 50 </tbody> Sheet B <tbody> A B C Name Policy Amount 1 Andrea 573 100 2 Gary 497 70 4 Shane 976...

Hi all, my currently code imports 1 csv data into sheet 1 and then I have to manually click the button and select the next csv file and import to sheet 2. Im thinking if it is possible to select all 3 csv data and import them to sheet 1, sheet 2 and sheet 3 all at once? any help is greatly...

Hi all :) I have two worksheets, one named Data and one named Index. In column G of Data, there is an index number. In column G of Index, there is a list of special index numbers. In columns A:F there is information about each special index numbers. What I need is in Data, if the index number...

Hi Mr. Excel, I use: Excel 2007, Windows XP, Internet Explorer. I would like to freeze both row 1 and row 2 and nothing below. When I select the top two rows(via the numbers to the left) and select "Freeze Panes" it freezes rows 1-11 instead of rows 1-2. Is there any way to fix this...