[ExcelVBA] Re: Newbie to group and Excel

 

Thank you David. This is exactly what I want.

Pam

--- In ExcelVBA@yahoogroups.com, "David Grugeon" <yahoo@...> wrote:
>
> Hi Pam
>
> I think what you want is certainly achievable. I am not however quite clear
> what that is.
>
> I think that all you want is to maintain a list of product numbers. Then
> you want to print these on physical pages in two columns so on page 1 you
> will have the product starting with A and when you get to the end of that
> column on page 1 you then continue in alphabetical order in column 2 of page
> 1. Then when column 2 of page 1 is full you go onto page 2 column 1. This
> is called snaking columns.
>
> To achieve this you need to start with all the product numbers in one column
> on one sheet. There are 1,048,576 rows on an excel sheet so it will
> probably be sufficient for the number of products you will have.
>
> You can click on the header of the column and then click the "Data" tab at
> the top and on this tab click the icon which has an A above a Z and then a
> down pointing arrow. This will sort the column in alphabetical order.
>
> Then, to produce the sheets for printed pages you set them up on the second
> spreadsheet (Sheet 2).
>
> Assuming your product names start at A1 on Sheet 1
>
> In sheet 2 put wording for a header for each page in cell B1 "Pam's
> Catalog"
>
> In cell A3 put the number 1
> In cell A4 put the formula =A3+1
> Copy this cell (Ctrl-C). Select cells A5 down to A49 and Paste (Ctrl-V)
> The formula should change automatically and you will have the numbers 1 to
> 47 showing.
>
> In cell B3 put the formula =INDIRECT("'sheet1'!A"&A3)
> Copy this down to all the cells down to row 49 like you did before.
> In cell C3 put the formula =A49+1
> Copy this down
> Copy the formula from B3 to cells D3 to D49
>
> Now go to cell A50
> Click the Page Layout tab at the top
> Click Breaks and then click Insert page break
> Now select cells A1 to D50
> Copy
> Select cell A50 and paste
> In cell A52 put the formula =C49+1
>
> You now have two pages of your catalog ready for printing.
>
> To add page 3 you select A50 to D99 and copy it to cell A99
> No further formula changes required.
>
> If you want more than 3 pages to start with you just continue pasting each
> 49 rows down.
>
> Now you can right click the Label A at the top of Column A and click Hide.
> Do the same for Column C
>
> You will need to change the width of columns B and D so the whole of the
> name can be seen.
>
> I hope this helps and that I have explained it in a simple enough manner.
>
> In Cell
>
> Best Regards
> David Grugeon
> Excel VBA Group Moderator
>
> -----Original Message-----
> From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
> Of Pamela
> Sent: Monday, 5 March 2012 6:26 AM
> To: ExcelVBA@yahoogroups.com
> Subject: [ExcelVBA] Newbie to group and Excel
>
> Hi, I'm Pa'm am in Ks and I need help with Excel Starter 2010. I'm new to
> this and what to make a spreadsheet to inventory cartridge I have. I would
> like to have 2 colums per page and have the ability to alphabetize the
> lists. Since I will be adding more carts in time, I also need the ability to
> add to list and then realphabetize it. Maybe abe able to go from one page to
> another and have the pages alphabetize through all pages.
>
> Can anyone help?
>
> Pam
>
>
>
> ------------------------------------
>
> ----------------------------------
> Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
> here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
> ARCHIVES for EXCEL VBA.
>
> ----------------------------------
> Visit our ExcelVBA group home page for more info and support files:
> http://groups.yahoo.com/group/ExcelVBA
>
> ----------------------------------
> More free tutorials and resources available at:
> http://www.mousetrax.com
>
> ----------------------------------Yahoo! Groups Links
>

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (5)

Recent Activity:

• New Members 10

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___