Excel 2007 : Need help linking using logic formulas

**luurkin** · 05-08-2012, 12:58 PM

So if I have numbers or words in Sheet 1 (being used as the main database). example

5 55632 dodge micheal susan 1999 Feb
9 99636 Ford rick steven 2005 November

lets say all the other worksheets in the workbook are named January(sheet 2), Feb(sheet 3), Mar(sheet 4), and so on. So if I enter the information like in the example and then enter Feb in the last cell. How can I get the forumla or code to link the prior row of cells into Feb(sheet 3) only. Maybe this will clarify what I need help with.

**dilipandey** · 05-08-2012, 01:31 PM

Hi luurkin,

Welcome to the forum.

Suggest you to please correct your thread title to reflect the query being asked... see the forum rules :-

http://www.excelforum.com/forum-rule...rum-rules.html

Regards,
DILIPandey

<click on below 'star' if this helps>

**SCLai** · 05-08-2012, 09:32 PM

I have only done Feb & Nov up to 20 entries for each, please take those 2 as reference & complete the rest.

Also, feel free to ask for explaination & help should you encounter any difficulity.

Hope this is what you needed!

SC

**luurkin** · 05-09-2012, 07:09 PM

I just got a chance to look at it. Its seems like you created what I was looking for. I will get a chance to look at it in depth tomorrow when I am back in the office. Thanks again SC and I will let you know if I run into any problems.