Re: $$Excel-Macros$$ Trying to group/flag data of same value together in sets

l the people you can, As long as ever you can.” - John Wesley - From: Paul Wilson >To: excel-macros@googlegroups.com >Sent: >Subject: $$Excel-Macros$$ Trying to group/flag data of same value together in >sets > > > >I'm t

$$Excel-Macros$$ Trying to group/flag data of same value together in sets

I'm trying to create a macro to evaluate the data in a specific column each row at a a time. The field/column name might be different each time. I wish at the same time to be able to compile/amend data based upon the number of same occurrences. In the example below each set can contain a maxim

$$Excel-Macros$$ Trying to autofilter 8-10 rows of numbers to sort in a group

I need to find "liked" number patterns within my spreadsheet that has around 500,000 rows. The data that I have entered looks like this: You will notice it has game numbers (column 1) and a location (Column 6) along with four numbers (column 2-3-4-5) that we will call counter numbers.Whe

Re: $$Excel-Macros$$ Trying to ExportAsFixedFormat - getting error "expected end of statement"

Hi! Thanks! I'm actually on Mac Office 2011 and it has a save as PDF option. That might be it, but I can't find a plug-in for mac... -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Form

$$Excel-Macros$$ Trying to ExportAsFixedFormat - getting error "expected end of statement"

Hi! I'm new to VBA and I'm trying to start out by creating a pdf out of my worksheet. This is my code: Sub PrintWorkbookPDf() ' ' PrintWorkbookPDf Macro ' ' Keyboard Shortcut: Option+Cmd+u ' ActiveWindow.SelectedSheets.ExportAsFixedFormat Type:=xlTypePDF FileName:=“sales.pdf” Quality:=xlQua

Re: $$Excel-Macros$$ Trying to calculate Number of Days to Deplete Inventory Stock for a Number of Stores

There is more to the story. I apply discounts accross the board to all the stores. I may have no discount for 5 days. Then I might run the program at 40% off for 10 days, 50% off for x days ^0 % off for X days etc. On 12/30/10, Ronald Cayne wrote: > I am performing a descending balance in column

$$Excel-Macros$$ Trying to calculate Number of Days to Deplete Inventory Stock for a Number of Stores

I am performing a descending balance in column B,C,D. up to 100 Stores. that incorporates number of days to arrive at that point based on some calculation. If the outstanding balance is less than 1 then I require the number of days to arrive at that point. in Column C to so indicated in Row 5

$$Excel-Macros$$ Trying to print specific worksheet from outlook attachment

Hi everyone- I'm trying to use VBA to print a specific "(1)ORDER FORM" worksheet from workbooks that I'm receiving in Outlook. I've constructed the following, but it keeps erring out when reaches the Worksheet("(1)ORDER FORM").Printout line. I receive errors ranging from error 9 to error 462 to er

$$Excel-Macros$$ trying to hire someone very very proficient in excel

i need help on a project to convert complex spreadsheets into a more efficient model. pls advise if anybody available ASAP. We could discuss the payment offline. Thanks -- -- Some important links for excel users: 1. F

Re: $$Excel-Macros$$ trying to delete cells that match search criteria

Err, the link doesn't show up completely in this e-mail. It is the Test_DeleteByNumberName file in the list of uploaded files. On Jun 9, 12:25 pm, molinari wrote: > Thanks a lot, Deepak. > > Here's the > file:http://groups.google.com/group/excel-macros/web/Test_DeleteByNumberNa... > > (I'm und

Re: $$Excel-Macros$$ trying to delete cells that match search criteria

Thanks a lot, Deepak. Here's the file: http://groups.google.com/group/excel-macros/web/Test_DeleteByNumberName.xls (I'm under an NDA, so I had to strip it of any meaningful information, but there are report numbers there for illustration). Two of the reports have the same "Number", called "In Fo

Re: $$Excel-Macros$$ trying to delete cells that match search criteria

Hi, Give me a sample file I will solve this for you. Regards, Deepak On Tue, Jun 8, 2010 at 8:35 PM, molinari wrote: > I have a list of reports to be printed out Monday - Friday, where each > worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made > another worksheet to list repo

$$Excel-Macros$$ trying to delete cells that match search criteria

I have a list of reports to be printed out Monday - Friday, where each worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made another worksheet to list reports that we no longer need (by their report number). I want the macro to go through the worksheet and delete the rows that corres

$$Excel-Macros$$ Trying

Based on the following description: "The Crystal Ball and CB Predictor Developer Kits allow users to completely automate and control Crystal Ball simulations and CB Predictor forecasts from within a VBA program or any other language outside of Excel supporting OLE 2 automation. The kits consist of