I want to take data blocks of 3 rows,
Cut and Move over a column and transpose to the next row.
This puts the data in Columns I can print labels from because of the field name.
Then loop down and get another block of three rows and repeat.
Re: Range using COUNTA
Thanks, that's what I need
Re: Range using COUNTA
I am wanting to set the print range and delete all rows below.
Example the range is A5 and E ??.
So I was going to use COUNTA to find how far down I should go. COUNTA formula is count if E5:E30 >0
If COUNTA has 16, then my range would be "(A5:E16) and delete all rows below E16.
I need to set a range using counta
the Range is "A5" & "E" COUNTA
How should I write that? COUNTA value is in cell E4
Re: Find last used row, delete un-used rows and total
I need to find the last Cell in Column C with a value in it and delete all Rows below and then Total column C.
I would also like to set used range to print.
Re: Copy formula from Row above if Cell Value changes.
Thanks, KJ, I never have used that function.
I copy a formula form Ozgrid and take to a new worksheet macro to paste and it does not appear in the paste function window.
I can copy and paste in the worksheet A1 but not to macros.
I want to copy the Vertical Lookup formula down from column B and C , from the row above when the VALUE CHANGES in Row A.
I then can use a last row macro to sum and place the Total below the last used line.
If I copy the formula all the way down when I make the worksheet , the lastrow macro gives me a total at the end, not below the last row used.
I have written a laymans Point of Sale with Barcoding ability.
I need help with a few macros to make it better and need some maros written. I recorded macros and obviously there are better ways to enter the data.
The place where I have the biggest difficulty is with the Barcode system and printing them on Avery Labels. I have made the Barcodes and the WASP reads them into the Sales sheet.
Where I get lost is I have say 45 items to print on the Avery sheet. It is laid out in columns of 2. Looks like the BarCodes are going to be about 1/2" x 4"
My data is all in one column. I need to move some into column "E" and "F" to make it fill up the sheet when it prints.
The other issues are very minor and can quickly and easily be done by someone knowledgeable with macro's VBA.
I would like to save to a disk drive and cloud system.
Time frame is a week.
The items highlighted in red are some of the minor issue about entering data. Example Sales tax.
If the customer decides not to purchase an item, I change the item to zero and it deletes out that transaction.
I can enter 9999 for discounts.
Need it to copy daily transactions and post to All Sales so I can have a Pivot Table to show details of the day/month .
I use the list function (Selection List) to insure accuracy in entering data
Re: Show Actual Display of Fonts based on the Font Description in Col "A"
I am copying a list of numbers with decimals but formatted to display fractions.
Example 10.125 shows 10 1/8 when formatted in the cell.
When I copy and post to my PLYWOOD cut list, it only shows the decimal. I would like it to show 10 1/8 as in the example, when posted.
I could do it with vertical lookup, but hoping there is an easier solution. I don't use anything less that 1/16
I have a macro from Microsoft which shows a listing of all my fonts in column "A" . I would like to have the actual display of that font to appear in column "B"
Example If I have "Arial " in Column "A", I would like for it to Display the actual font that is associated with the name, "Arial", in column "B".
Re: Convert decimal to text fraction
Thank you. That worked
I enter data as a decimal. Like 20.25
I would like to covert that to 20 1/4 in text form so I can copy and add it to the description in a plywood cut program.
I can change the format to factions in Excel, but when I copy and paste it reverts back to decimal. The most would have 3 decimals like .125
Re: Find Letters inside a word
Thanks, that works and will keep me from keying in all those stock transactions.
I need to extract the Stock Symbol from the description for IRS form.[tr]
[TD="class: xl63, width: 273, bgcolor: transparent"]APPLE COMPUTER INC (AAPL)
I need the characters between the ( ) AAPL
Some may only be two characters like GE[/TD][/tr]
Re: Merge Excell to Word and Print Label with Inserted Shape
I did find this from Avery http://www.avery.com/avery/en_…-for-Microsoft-Office.htm which is great for printing labels from Excel, but still not Arrow images.
I used this helpful tutorial to merge my Excel worksheet http://www.wa.gov/esd/training…rgewithExcelDataFiles.pdf, but the inserted Arrow shape did not post.
I am wanting to print on transparent labels with the arrow pointing to specific data.
After the merge, I only got the numbers with no arrow.
I am using Avery 1/2 x 1 3/4 8167 labels.
Naturally I could spend a lot of time and eventually get them to line up in Excel but was hoping to find a better way.forum.ozgrid.com/index.php?attachment/66193/
I have the attached Excel converter file to use Excel data and make a DXF file for cad.
The problem is I can't get it to work . Get error Run Time Error 75 , Path/file access error
Open f$ For Output As #1 is high lighted in the macro