software

Im wondering if there is an easy way to copy select columns
D, E, H, I to columns A, B, C, D to another workbook (E to A)

Then I have to filter by name in column A of new workbook and save a
file for each name. Is there a way to automate this procedure?

Thanks
Reply With Quote--
hachiroku
------------------------------------------------------------------------
hachiroku's Profile: www.excelforum.com/member.php...oamp;userid=34039
View this thread: www.excelforum.com/showthread...hreadid=537996You could have a macro do the work for you.

You may want to try Ron de Bruin's Easyfilter:
www.rondebruin.nl/easyfilter.htm

Or look at the way Debra Dalgleish does it:

Debra's site:
www.contextures.com/excelfiles.html

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb

or

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- replaces old data with current.
AdvFilterCity.xls 55 kb

hachiroku wrote:
gt;
gt; Im wondering if there is an easy way to copy select columns
gt; D, E, H, I to columns A, B, C, D to another workbook (E to A)
gt;
gt; Then I have to filter by name in column A of new workbook and save a
gt; file for each name. Is there a way to automate this procedure?
gt;
gt; Thanks
gt; Reply With Quote
gt;
gt; --
gt; hachiroku
gt; ------------------------------------------------------------------------
gt; hachiroku's Profile: www.excelforum.com/member.php...oamp;userid=34039
gt; View this thread: www.excelforum.com/showthread...hreadid=537996

--

Dave Peterson


It is possible to do what you want by a macro.

the data you copy from the master workbook is it to contain only the
data for the one name to a new workbook and that new workbook saved
with a file name based on that name.

Or do you want all the information from the master book to be saved to
each new book withh only the rows visible that = the one name.--
mudraker
------------------------------------------------------------------------
mudraker's Profile: www.excelforum.com/member.php...foamp;userid=2473
View this thread: www.excelforum.com/showthread...hreadid=537996