Unanswered: Create sheets from one sheet based on value
i have Excel sheet with thousands rows.
Lets say that first 400 rows in first column contain the same value (lets say A), other columns different..
Second 400 rows have the same value in the first column (lets say B).
Is it possible to write macro that creates two sheets, first sheet will contain first 400 rows wit value A and secon sheet will contain second 400 rows with value B?
Could you give me an Idea how this macro should look like? i am newbie with macros
Why do you want to do this?
It might sound like a good idea but from experience I can tell you it becomes a bit of a maintenance nightmare!
Reason to do this is, that i am exporting data from MS Access. I have report in access which contains many data.
For my next work i need to get tables based on values in first colmumn. It looks like this>
1.column 2. column 3. column
a 20 50
a 30 30
a 10 60
b 110 160
c 210 60
c 310 60
and I want to get sheet that have just values in rows with a, second sheet with values in rows with b....etc
and also i have a lot of such big reports..
Last edited by gvee; 06-04-14 at 09:43.
Reason: code blocked.
So you could end up with 10,000 worksheets if you're not careful!
Personally I would just put all the data in a single sheet and then use column filters to show only those I am interested in.
yeah man, i am thinking about it and you are right. I realized that I need to make report based on multiple tables/queries where can i get data based on value in column and then just export it...