Excel VBA nested if statements

[dolphinideas1]

I am having trouble performing a certain action in excel 2007 using VBA. I have several columns containing stock information which I would like to separate by stock ticker. I may have anywhere from 2 to 8 rows of information relating to a single stock ticker. I would like to copy and paste these values to another part of the spreadsheet. For example I have the following VBA code which uses nested if then statements to compare cells in the AO column for the same stock ticker and copies the correct number of rows to CA4. When I try to use separate if then statements to compare AN3 to AN4 and copy one row if true, compare AN4 to AN5 and copy one row if true, etc. Once it compares two cells that don't match it still keeps copying them as if the result was true. I can only get it to work by checking from the bottom, starting with false comparisons and working my way up to end with true comparisons. Also I would like to be able to copy each stock ticker to a separate area, such as copying the rows for AAPL to CA4, and the rows for AIG to CA37 for example. Please see the attached excel file for reference. https://www.dropbox.com/s/wyhbizqfzb..._VBA.xlsx?dl=0


Thank you so much for your help,

Alex.

Please Login or Register  to view this content.

[JasperD]

dropbox link doesn't work.

[FDibbins]

Hi, welcome to the forum

Please upload your file to the forum. many members are unable - or unwilling - to download files from file hosting sites.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[protonLeah]

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.