section

Hey, I have a problem if I want to print something in a Worksheet. The sheet has different sections which you use a macro to hide the other columns. If I click on the second section and want to print it only shows me the header which its freezed but the the rest shows blank. Can somebody help...

Hi all, I have this code: Dim n As Series <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans...

Hello XLers, I want to get some data from a web page. But the From Web button shows me a dialog that allows me to click an arrow button, to get that section of the web page. But the section that I want does not have an arrow? Am I missing something?

Hello, I'm working on building an analysis tool and have hit a bit of a roadblock. I have a data set for a list of vendors in rows and type of scope across the columns. I also have a "Preliminary" vendor in the uppermost row of values which represents a budget. Both the count of vendors and...

Hi all, Havethe following which works fine as a formula in the workbook: Range("AD2") = "=DATEVALUE(TRIM(MID(AE2,FIND(" ",AE2),3))&" "&LEFT(AE2,FIND(" ",AE2)-1)&" "&TRIM(MID(AE2,FIND(" ",AE2,FIND(" ",AE2)+1),5)))" However, if I try and use it in VBA I am getting a syntax error (expected End...

For example, robin Williams, if you have it as field filtered down in the filter section, can it also list his name in the rows section?

I think this should be relatively easy to answer but my code keeps popping an error and I can't figure out why I am trying to take a section of another workbook and paste the values in a section of the workbook that I am working in: Sub GetDemandPlan1() With Sheets("Paste Day 1 Demand Plan...

Looking to do something like this on a Command Button If Range("N9").Value = Range("E8").Value Then 'Run another if statement code here' If Range("N9") = "" Or Range("O9") = "" Or Range("P9") = "" Then 'Do Nothing' 'If Cut Section, Length, And Width Is NOT Empty...

I am trying to build a formula that will verify a word in the first section and in another section, however if the word was to change the. It will produce a separate result. I have been able to complete it for one result but once I try and build upon it the formula no longer works. It says I...

I need a code to look down the column and at the end of Column B in each section (there are two sections) place the word "Total" and then sum columns C thru I in each section with a single line at top and a double line at bottom of each section.

Good Afternoon, I am trying to do a sumif or countif based on a date range. I can get the countif section to work with no issues when I remove the red txt section. I am trying to get column E to add together anything with "E" + "DF" togther based on the date in column B, Active in Column D and...

Good day all, The time sheet currently used was created in MS Word and updating it every month requires updating quite a few cells (Individual Days, End of Week, Current Month, etc.) so to save time I translated the time sheet into Excel keeping an almost identical layout. The existing MS Word...

Hi, I have the following array formula: {=IFERROR(INDEX(MasterTable!$D$2:$GC$165,MATCH(1,IF($AA4=MasterTable!$C$2:$C$165,IF($AB4=MasterTable!$A$2:$A$165,1)),0),MATCH($X$3,MasterTable!$D$1:$GC$1,0)),"nothing found")} I would like to refer to a value in say A1 instead of the above highlighted...

Hi, I have a question about creating a Venn diagram and want to know if it's even possible. The data I would want would be something like: Name - John English Speaker - Yes Disability - Yes Working - No What I would love to be able to do (and don't know if it's at all possible) is that a Venn...

I just finished created all the reports I need for our directory and now I would like to put all on them on one continuous report as opposed to separate reports. This report would be sent to a PDF to be sent to the printer for publication. For some reason, on the detail section of some of the...

Can I use logic operators in the array section of a sum(countifs formula? Example: =Sum(Countifs(item.range,A3,location.range,B3,date.1.range,{"<"&A1,">"&Eomonth(A1,0)}) A1 is a date, typically the 1st of any given month. I have tried it and it doesn't seem to work as expected. Any...

Hello, I am hoping that someone may be able to help me out as I am trying to find a method to copy information from a form that I have created that has a comments section on one worksheet to a USER NAME verified comments section on another worksheet. I hope that this is self explanatory and if...

Hello everyone! I currently use the following formula: =COUNTIFS('CLEX01 '!$K:$K,'TEST REPORT'!H5,'CLEX01 '!$A:$A,'TEST REPORT'!H4) Column 'CLEX01 '!$K:$K - it's the day something was completed Cell 'TEST REPORT'!H5 - a cell where a user can change the date to generate a report Column 'CLEX01...

I need my spreadsheet to automatically insert a sequential number to all cells in column A (beginning with row 14) with the exception of the rows that contain bold text (header rows if you will, for each category). I also need to be able to add or delete rows and have the numbering auto correct...

I know how to write literal text, or the contents of a string variable into the notes section of a powerpoint slide. But how can I capture the text that's in an Excel textbox in order to do the same? If I record a macro when copying the text out of a textbox I get something like this...