from sheet1 to sheet2

[k0st4din]

Hello everyone,
I want to apologize if I have not found the answer to my question, and it is this related to excel - I have 36 sheets, in the first sheet I have a 5000 order, my idea, I want to do, but do not know how is this a each sheet with the name 1000, 2000, 3000, etc. up to 35 when 000 is on the first sheet in column A2 to A5000 have numbers from 1,000 to 35,000 but mixed (eg 2000, 25000, 7000, 8000, 4000, 7000, etc.) against them wrote something that might not understand because it is in Bulgarian, so my idea is if the A2 has 2000 it went into the sheet name with 2000 and everything else that is written against him if it is 4000 to go to sheet 4000 and named it with everyone else. I will attach a small chart to understand my idea and hopefully someone can help me, as I will be grateful in advance.

[watersev]

hi, k0st4din, please check attachment, run code "test"

[k0st4din]

hi, k0st4din, please check attachment, run code "test"

Hello, I have VBA code, I do not know how to do it, I mean that looking for some sort of formula offset with something else such as lookup or Vlookup. I do not know how to be tried in what way you do not, but obviously there is something that eludes me and I can not touch things. What do you mean a check attached - you can not open it or read it if you search for the code - I have no.

[watersev]

hi, download and save the attached file "Копия Образец(1).xls", open it up and follow instructions given below:

http://office.microsoft.com/en-us/ex...306.aspx?CTT=1 - English

http://office.microsoft.com/ru-ru/ex...6.aspx?redir=0 - Russian

How to run a macro from Microsoft support site.