RE: $$Excel-Macros$$ Lookup variable sheet name

Paul, Thank you for your patience . . . I now see it! Steve From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Sunday, November 26, 2017 9:53 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup variable

$$Excel-Macros$$ CLEAR DISTILLATE CARTRIDGES,WAX AND SHATTER,CANNABIS OIL..... +1 (386)232-8514

$$Excel-Macros$$ INDICA AND SATIVA STRAINS, RSO OIL, BHO AND THC OILS FOR SALE...+1 (386)232-8514

$$Excel-Macros$$ Re: Want to get your question answered quickly?

hy it doesn't work ? Thank you, Steve Private Sub Worksheet_chage(ByVal Target As Excel.Range) Dim rCell As Range Dim rChange As Range On Error GoTo ErrHandler Set rChange = Intersect(Target, Range("A:A")) If Not rChange Is Nothing Then Application.

Re: $$Excel-Macros$$ Two-dimensional array with numbers and "#N/A" - turn "#N/A" to blank cells

I believe you can accomplish by enclosing your formula as follows: Iferror((your formula),""). Steve Sent from my iPhone > On Jun 26, 2014, at 4:34 PM, Gerrit Grundling > wrote: > > Greetings, all > > I have aerofoil data for a selection of Reynolds numbers and

Re: $$Excel-Macros$$ Help with Complex formula

Pramod, Thank you . . . Works perfectly! Steve Sent from my iPhone > On Jun 26, 2014, at 2:09 PM, Pramod Singh wrote: > > Hi Steve, > > Hope this will fine for you, > > > Regards > Pramod > > >> On Thu, Jun 26, 2014 at 9:54 PM, SteveWeave

Re: $$Excel-Macros$$ What am I missing????

uot; > > > > >> On Wed, Apr 9, 2014 at 9:31 PM, Steve Weaver >> wrote: >> >> >> Here is what I’d like to accomplish: >> >> · Select the desired ReportPeriod from the drop down list in cell J3 >> on the “Monthly IS” tab >>

Re: $$Excel-Macros$$ Maintaining format when pasting data into a template

Thank you Anoop for your suggestion. Since I am an accountant and was not involved in writing the code, would you be a little more specific and show me exactly where this code should be placed. Thank you again for your generous help. Steve On Thursday, August 1, 2013 10:30:45 PM UTC-4

$$Excel-Macros$$ Re: Maintaining format when pasting data into a template

Thank you Anoop for your suggestion. Since I am an accountant and was not involved in writing the code, would you be a little more specific and show me exactly where this code should be placed. Thank you again for your generous help. Steve On Thursday, August 1, 2013 8:31:42 PM UTC-4

$$Excel-Macros$$ Conditional functions based on multiple criteria

Good Afternoon, I am trying to find a way to do conditional functions based on multiple criteria and I can't seem to find a way to do this. *What I have:* Multiple columns of information: ID, Day of week, Week of, and Start Date/time, End day/time *What I would like:* I'd like to subtract the

Re: $$Excel-Macros$$ Returning a cumulative value based on the contents of a given cell

Perfecto!!! I believe I got it now. Thanks everyone for your help. Steve *From:* Steve Weaver <mailto:steveweave...@comcast.net> *Sent:* Wednesday, August 29, 2012 11:24 AM *To:* excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> *Subject:* $$Excel-Macros$$

Re: $$Excel-Macros$$ Returning a cumulative value based on the contents of a given cell

Perfecto!!! I believe I got it now. Thanks everyone for your help. Steve *From:* Steve Weaver <mailto:steveweave...@comcast.net> *Sent:* Wednesday, August 29, 2012 11:24 AM *To:* excel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com> *Subject:* $$Excel-Macros$$

Re: $$Excel-Macros$$ Retaining headers and footers when creating a new worksheet

Thank you Sam! That's exactly what I wanted. Steve On 1/13/2012 9:17 PM, Sam Mathai Chacko wrote: Regards, Sam Mathai Chacko On Fri, Jan 13, 2012 at 10:58 PM, Steve Weaver mailto:stevebwea...@comcast.net>> wrote: Greetings, Several months ago I received help from th

Re: $$Excel-Macros$$ Making Chart more useful to readers

Thank you Sam and Don for sharing your knowledge. You guys are GREAT! Steve On 11/19/2011 1:13 PM, Sam Mathai Chacko wrote: For some reason, the named range with an INDIRECT formula isn't getting accepted within the chart. Had to change the formula to =OFFSET($A$7,1,0,13,1), assuming

Re: $$Excel-Macros$$ Making Chart more useful to readers

ke to show the chart in the most meaningful way possible. If that means making the chart look differently, I'm open to that suggestion. Hope this helps! Thanks! Steve On 11/19/2011 8:25 AM, Sam Mathai Chacko wrote:

Re: $$Excel-Macros$$ Create worksheet from list

raw data. I should have deleted the subtotals as well but didn't. That's why you see the strange subtotals. In any event, the code now does what I need it to do thanks to your generous support. Steve On 10/5/2011 10:18 AM, dguillett1 wrote: I have re-written to simply delete

Re: $$Excel-Macros$$ Need help with forecast formula

Thank you Sam for your suggestion but I still can't get the formula to work. In case it makes a difference, I'm using Excel 2002 with SP3 installed. What am I missing? Steve On 9/25/2011 2:48 PM, Sam Mathai Chacko wrote: Try =FORECAST(O8,$E$6:E7,$O$6:O7) in M8 and drag down

Re: $$Excel-Macros$$ Filtered Info must come into the Header or Footer

Hello Mahess, I haven't changed the logo of the file but it's format. If you check the file extention of the file it is .xlsb Thank you Steve. On Thu, Sep 15, 2011 at 11:10 AM, Mahess Desai wrote: > Hi! Steve, > > When I down loaded your attachment, found that the Excel file

Re: $$Excel-Macros$$ Filtered Info must come into the Header or Footer

Dear Noorain, Thank you very much for your quick respose. I am attaching a modified file from excel-macros@googlegroups.com, with my request. Thank you once again. On Tue, Sep 13, 2011 at 10:55 PM, NOORAIN ANSARI wrote: > Dear Steve, > > Can you u provide excel sheet with Example.. &

$$Excel-Macros$$ Filtered Info must come into the Header or Footer

he header or footer. 3. Automatically it must add a word or words related to the filtered word. eg. If I filter 'Boy' then can it have a "Boys Only" Thanking you in Advance. Bye for now Steve -- -- S

Re: $$Excel-Macros$$ Need help with advance filter

Thank you dguillett!! I'm not real sure how this works or what to do with it. Could you please explain to me each step in "baby talk" ? Thank you! Steve On 9/10/2011 10:31 AM, dguillett1 wrote: From

Re: $$Excel-Macros$$ Re: Help with Formula

Sam, thank you so much . . . the formula works GREAT!!! Steve On 8/20/2011 1:05 AM, GoldenLance wrote: Use =INDIRECT("'2011 Forecast'!"&ADDRESS(28,MATCH(TEXT(J3,""),'2011 Forecast'!$A$2:$X $2,0))) in Monthly IS, range F9 Steve, sure you can

$$Excel-Macros$$ consolidating multiple sheets to one sheet

sheet 5) followed by 145 lines of data. I'm new to thisw stuff, but you guys have always been very helpful to me before (and you make it look so easy) If more explanation is needed you can send questions through my gmail a

$$Excel-Macros$$ How to use a drop down list to select data from another sheet

selected. However, I am having trouble doing this via the lookup function and ask for your help. I have uploaded the spreadsheet "Copy of Actual vs Forecast FY11.xls". Any help or advice offered will be appreciated. Thank you! St

$$Excel-Macros$$ Bulk search and replace

th "Martin Luther King." Another example would be replacing any instance of "Desoto" with "De Soto." Any ideas on a good way to do this? Hopefully including a way for me to continue to add words (and their

$$Excel-Macros$$ row based on contents of 1 cell

greatly appreciated. Thank you, Steve -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http

$$Excel-Macros$$ Next Empty Row Code not Working

ay be causing this would certainly be appreciated. Thanks, Steve Private Sub CmdAdd_Click() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("ECO") 'find first empty row in database iRow = ws.Cells(Rows.Count, 1) _ .End(xlUp).Offset(1, 0).Row + 1 'copy the data

Re: $$Excel-Macros$$ Save As Excel Workbook Macro

Andy, Thanks for the link. I've book marked it to try out some of the stuff in there. Regards, Steve On Aug 12, 9:52 pm, Aindril De wrote: > Hi Steve, > > In Excel 2007 certain things have changed in the VBA front as well. While > saving the file in any XML format that is .

Re: $$Excel-Macros$$ Save As Excel Workbook Macro

Thanks Paul. I read through what you had and changed the file format to: FileFormat:=xlOpenXMLWorkbook And that solved my problem. Regards, Steve On Aug 13, 9:14 am, Paul Schreiner wrote: > There's a couple of key statements you've made: > > "I went to update i

$$Excel-Macros$$ Save As Excel Workbook Macro

Formula references to data in this region will return a #REF! error." Anyhow, I'd like to figure out what is causing the pop-up for compatibility to show up and figure out why the file that is being created now is corrupt and won't open. Thanks, Steve -- --

$$Excel-Macros$$ Re: Help creating chart

chosen month. 3. I would like to repeat steps 1 and 2 for the quarter and also the YTD. Any additional thoughts or comments are appreciated. Steve On Jul 28, 2:28 am, "Kishan Reddy, K" wrote: > Hello, > > Obviously you will have a data sheet on which you have created the >

$$Excel-Macros$$ Re: Help creating chart

The spreadsheet can be found in the files section and is titled "Net Sales Chart.xls". Steve On Jul 27, 7:43 pm, Steve wrote: > I need help! > > I am trying to adapt a neat little spreadsheet for my use in graphing > monthly, quarterly, and year-to-date sales for

$$Excel-Macros$$ Help creating chart

. month, quarter, or year-to-date? Thank you in advance for your help. Steve -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Macro required for Auto fill

ms someone was asking the same question at about the same time and you camme up with similar solutions. Since I often use this on sheet with well over 1,000 lines I'm finding myself highlighting 2 or 3 entire columns and triggering it. Do you know of a way to keep it from copying the last da

Re: $$Excel-Macros$$ Filling in cells from cell above

On Apr 27, 2:43 am, Swapnil Palande wrote: > Hi Steve, > > Please find attached excel for solution. Select the cells ( from first 3 > columns) where you want to fill data and go to "MyTools" in menubar and > press "Fill Data". > > Regards, > > Sw

$$Excel-Macros$$ Filling in cells from cell above

the way down column A to row 9, then copy the data from A,10 and insert it all the way down to row 24, copy A,25 and insert it all the way down to row 41, etc. I can provide samples if necessary. Thanks, Steve sca...@aol.com

$$Excel-Macros$$ subtracting time

Hello, I need to subtract a specific time in one cell from another time another cell to produce the difference of the two times. I also need to consider passing through midnight, i may have a time on one day and have to subtract it from a time on the next day. Thanks in advance, Steve

Re: $$Excel-Macros$$ compare partial text in a cell and compare the information for a new cell

No futher enhancements are necessary at this time you have fulfilled all of my requirements, quite remarkably Imight add, I appreciate everyone's efforts a great deal. I am looking forward to becoming a regular member of this group, as I have learned a great deal from you. Thanks again,

Re: $$Excel-Macros$$ compare partial text in a cell and compare the information for a new cell

No futher enhancements are necessary at this time you have fulfilled all of my requirements, quite remarkably i might add, i appreciate everyone's efforts a great deal. I am looking forward to becoming a regular member of this group, as i have learned a great deal from you. Thanks again,

$$Excel-Macros$$ Re: compare partial text in a cell and compare the information for a new cell

I didn't realize that the formatting would change, while i am at it, i would like to search for 1a or 1b or 1c and have it put the corresponding location in the appropriate cell. please see attachment. Thanks again, Steve On Sun, Jan 24, 2010 at 5:49 PM, Steve wrote:

$$Excel-Macros$$ compare partial text in a cell and compare the information for a new cell

is found have excel return the location(Tampa Fla.) in a new cell (B1). This problem seems very easy, but i am having trouble getting exactly what i need. Thanks for the help, Steve -- -- Some important links for excel

$$Excel-Macros$$ identifying duplicates

omparing a few other lists to this master list looking for people that appear on both. Thanks, Steve -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-in

Re: $$Excel-Macros$$ Concatenate, including blank fields

never know where the space is going to be. I think I found the problem, there's not a blank space in the actual blank cell. I'm going to play with it some more and work on it. Thanks, Steve -- -- Some impo

Re: $$Excel-Macros$$ Concatenate, including blank fields

(all together by pressing ALTt+Enter) . > > I hope this will help you > > Regards, > Kapil. Ok, I think I can get it to work from here. Thank you for the help. It appears that the person that made up the sheet tabbed over the blank cells instead of

$$Excel-Macros$$ Concatenate, including blank fields

I am trying to concatenate 8 columns, all of which containe either a single character or a blank. When I use the concatenate funciton it leaves out the blank spaces and runs all the letters together (without spaces). Is there a way that a blank cell can be concatenated as a blank space? Can I

$$Excel-Macros$$ How to predict row height from font size?

correct!) 200pt * (1.214em) * (1in / 72pt) * 96dpi = 323.733px -> rounds to 324px (243pt -- should be 244.5!) Does anyone know how to accurately predict this? if so, what is the formula that will give the results I

$$Excel-Macros$$ Re: delete entire row based on single cell value

Wow, that works great, thank you very much. I was trying to hack through it and was up over 50 lines so far, I see I was on the completely wrong track... Thanks, Steve

$$Excel-Macros$$ delete entire row based on single cell value

pped. Going from the bottom to the top is fine. I am still hacking away in VBA trying to get it to work but, not knowing VBA and not being able to figure out some of the error messages has me a little behind the curve. Tha

$$Excel-Macros$$ Simple VBA Data validation query

Hi, Hopoing someone will be kind enough to help me with this simple query. I have a spreadhseeet, and want to write some vba code which says if the value of cell a2 is greater than the value of cell g3, then display a message saying "Value cant be higher than effort"

$$Excel-Macros$$ Limit a Listbox

can examine and apply it to an application I have in mind for work I would really really appreciate it? Please advise. http://www.dicks-blog.com/archives/2005/02/16/limit-a-listbox/

$$Excel-Macros$$ Re: Combo box macro

I was going this route because of the autocomplete capabilities. I should have mentioned that in my post. Any ideas as to how I can do this would surely be appreciated. Thanks, Steve On Jun 1, 8:08 am, norie wrote: > Steve > > Why not just use Data>Validation... with the

$$Excel-Macros$$ Combo box macro

the combo box in cell A4, I need the linked cell field to refer to B4. Any help much appreciated. Thanks, Steve --~--~-~--~~~---~--~~ - Some important links for excel users: 1

$$Excel-Macros$$ Re: Export selected worksheets into new workbook from list box

Thank you for the help! On May 15, 1:53 am, bala wrote: > hi > your code process all the sheets listed in list box, check if > List22.Selected (x)  = true then selected value & do the process > > Private Sub CommandButton1_Click() > Dim Lst As String > Dim x As Long >     For x = 0 To ListBox1.L

$$Excel-Macros$$ Export selected worksheets into new workbook from list box

I have a UserForm with a multi-selection ListBox (ListBox1) that is populated with all the worksheet names. Based on the user's selection (s), I am trying to export (copy/paste values & formats) for only those selected worksheets when he/she clicks a CommandButton (cbRunExport). I keep encounter

$$Excel-Macros$$ Re: Data extracting issue, perhaps a lookup a problem

Perfect. Thanks, Steve On Apr 19, 10:32 am, Ashish Jain <26may.1...@gmail.com> wrote: > Hi Steve, > > If we leave the weekend part, your problem is solved. > You can use pivot table. Put work order in Row field and > Count of Dates in Data field. Problem is solved (partiall

$$Excel-Macros$$ Re: Conditional Formats on Cells

ting on that row. Otherwise, if only L2 was blank, then change the color. Regards, Steve On Apr 21, 10:38 am, rspowell wrote: > Steve -- > > Excel 2003 is limited to 3 conditions > > -- since you are talking about 5 or 6 conditions, you must be working > in Excel 2007, without

$$Excel-Macros$$ Conditional Formats on Cells

Hi, Can anyone tell me if there is a limit on the number of conditions you can place on a cell? I've got 5 and actually need 6, however, when I select apply, the last condition disappears. Please advise,

$$Excel-Macros$$ Re: Message Box

Wow, I just saw this. I'll give a try on Monday... Thanks, Steve On Apr 16, 9:39 pm, Dave Bonallack wrote: > Hi > > Try this in your code: > > Do until IsDate(Answer)=True > >   Answer = InputBox(Message, "Date") > >   If IsDate(Answer) = False The

$$Excel-Macros$$ Another Message Box Question

Hi, Can anyone tell me how I would go about setting up a Msgbox to pop-up for a period of 10 seconds, with an option for the user to hit the Enter key to escape out of it sooner if they wanted to. Please advise, Steve

$$Excel-Macros$$ PivotItems filtering problem

essage when the macro gets to this point. Basically, I need to only see those Work Orders that are at "L" and "C". If there are no more at status "C", then all I need to see is "L". Any assistance on this would be greatly appreciated. Regards, Steve

$$Excel-Macros$$ Re: Message Box

Dave, The following seems to work from your suggestions. How would I go about putting at trap in there to make sure I get a date entry in that cell? Thanks, Steve Sub Est_New_Project_Start_Date_InputBox() ' ' Est New Project Start Date InputBox Macro Sheets("Sheet1&quo

$$Excel-Macros$$ Re: Message Box

Thank you. I'll give it a try when I get to work this morning. Regards, Steve On Apr 16, 2:30 am, Dave Bonallack wrote: > Hi Steve, > > I think the simplest way would be a two-step approach, something like: > > A = MsgBox("Do you want to enter a date?", vbYesNo)

$$Excel-Macros$$ Message Box

Hi, I need to insert a message box in the middle of a macro that will request the user to enter a "Start Date" or give them the option to skip it and let the macro continue running. Any help would be deeply appreciated. Than

$$Excel-Macros$$ Pivot Table Formula

ally, I need the Count of the items from my W/O# column that match the same criteria above. I have the following that doesn't work. =GETPIVOTDATA("ST Time",SUMIF(H8:H508,"*-010N-*")) My Column Label field name is "W/O#&quo

$$Excel-Macros$$ Re: Concatenate Macro

Exactly what I was looking for Thanks, Steve On Apr 7, 5:55 am, Dave Bonallack wrote: > Hi Steve, > Try this code. It assumes data is in Columns A and B, as stated, and that the > data starts in Row 2. > > Sub Steve() >     Application.ScreenUpdating = False >

$$Excel-Macros$$ Dcount or Countif?

I have a spreadsheet with 5 columns and need to count the number of responses between a range based on the criteria of two cells. For instance the range is A1:E16 Columns A = Name B = Address C = City D = State E = Age Criteria A1 = Jack D2 = Michigan Count Brackets: Age = 20-29, 30-39, 40-49,

$$Excel-Macros$$ Concatenate Macro

e 100-344 Shipping crate with pallet. I need the information in column B to be concatenated onto one line, preferably in the same row as the Part Numbers. Any help would be much appreciated. Thanks,

$$Excel-Macros$$ Data extracting issue, perhaps a lookup a problem

a Saturday or a Sunday, then I need to subtract that day from my total number of days. Any help would be greatly appreciated. Thanks, Steve --~--~-~--~~~---~--~~ - Some important

$$Excel-Macros$$ Re: Need an option to select any text file when importing into a worksheet

Thanks Dave, I'll give it a try when I get back to work tomorrow. Regards, Steve On Jan 18, 3:46 am, Dave Bonallack wrote: > Hi Steve, > Ignore the first email. It was incomplete. > Try this. Remember the extra End With near the end. > Regards - Dave. > >     Di

$$Excel-Macros$$ Need an option to select any text file when importing into a worksheet

aTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1) .TextFileFixedColumnWidths = Array(20, 88, 60, 6, 2, 60, 30, 12, 1, 20, 4, 9, 6, 12, 10, _ 10, 12) .TextFileTrailingMinusNumbers = True .Refresh BackgroundQuery:=False End With End Sub Any help would