Dear All,
I have a sheet in which complete information is available. Requiered is to distribute this information in multiple sheets based upon entries in a column in the main sheet.
One easy way to do this is by using macro. However I do not want to use this feature due to security and sheet portability problems.
I can do the same by using the if condition formula in each cell of other sheets to copy relative information. Problem with this method is that there will be empty rows when the information does not match for that sheet condition. Then it will be requiered to delete the extra rows.
Isn't there a simpler way possible without using any macros. So the rows are copied to destination sheets without intermediate spaces.
Best Regards
Thank you for your time reading this problem!
Last edited by mabs239; 05-31-2010 at 02:59 AM.
A recent poster asked the same thing. Attached is the sample file we created together showing a way to do it with "key columns" for each code desired to separate out the data. No vba, but it can result in a very large file.
(see attached)
Personally, I would use a macro, it's fast and handles any set of data and number of sheets with ease. I have a macro on this page to do it if you decide to go that route:
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
JBeaucaire Zinda Bad, Excel Forum Zinda Bad
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Dear JBeaucaire,
I have detcted a small problem with the sheet. If a category in index column is missing then the corresponding sheet shows errors (#N/A) in all cells. I had to solve this problem as my main sheet does not necessarily contain all the categories as it is flooded with the reports collected on daily bases.
It was observed that the first index number in the child sheets is written as "1", without any condition.
Problem is solved when repalaced by following conditonal statement [in cell A5]:
=IF($A$4<1,"",1)
I downloaded the macro sheet from your website. It didn't work for me. I must appreciate that your google site is a nice collection of excel tid bits. Thanks for being so helpful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks