true

I have a code to fill in multiple PDF files from data in an excel sheet. It gets data from the first row and fills in the pdf and saves it. Then I need it to go to each line and fill in a new pdf and save it. When it creates the first pdf and saves it, a preview of the pdf comes up. Then the...

Hello everyone! I'm looking for the easiest way to find the last time "X" occured in a column via a module I'm calling test for now. Specifically, find the last time "X" occurs in col g on sheet2 lets say, if true, offset(7, 0) and then put "X" in that cell from the offset. TIA

Hi Folks, Need help on the Pivot setting or option I can use to allow me show the percentage of TRUE on the column from each month see sample result below. RAW Worksheet <tbody> A B C D 1 DateM SLA Met 2 Sep TRUE 3 Sep TRUE 4 Sep TRUE 5 Sep TRUE 6 Sep FALSE 7...

A simple =IF statement checks a value in a cell on a different worksheet for TRUE/FALSE and performs the string paste accordingly. I have removed the "" from around the boolean TRUE/FALSE. The boolean values are copy/paste value from another workbook. Some formulas will update, many will not...

I apologize if the title of this post is confusing. I have an Excel sheet that can have up to 10 entries. I have a drop down in AA3 with #'s 1-10. Based on the selection in that box, I need a certain number of rows to be hidden. If 1 is selected, I need a certain set of rows, if 2 is...

Hello, I've been using this macro for months without issue but today I keep getting the same error. What the macro is doing is opening csv files and saving them as xlsx files. I have highlighted in Blue where the error occurs. I'm not sure how to fix... any help/guidance is much appreciated...

Hi All, I'm trying to out a condition whereby if my sub produces a "Positive result" then that row gets locked. I'm working with Column B in range of ("B8:B66"): x = ActiveSheet.Range("B8:B66") found = True For Each cell In Range("B8:B66").Cells If cell.Value = "X" Then found...

Hi I have the following data on a sheet. It is basically a calendar that shows a persons days off. Role 0 are fixed days off people. Role 1 is to be ignored. I want a conditional formatting to be true when the following are satisfied: 1. Column B = 0 2. If the day (Row 1) for the...

Hi All, I've come to the conclusion that I don't know how to do this. I've tried to lock a row with a code but it appears to lock every row. For example; If I'm trying to lock Range ("B10:M10") but after I run my code it locks every row that has an entry. Very strange to me...

Column B2:B7 is EITHER of 1 OR 0 Input Data Range D2:H7 is EITHER of TRUE OR FALSE Input ‘Header’ (above D2:H7) i.e. D1:H1 is 111, 222, 333, 444 & 555 Output Range J2:N7 as shown: How to accomplish. Thanks in advance I am using Excel 2007 Sheet2 <colgroup><col style="FONT-WEIGHT: bold...

Hi. I got this code (below), that users submitt some text and values, then it saves the file as a .pdf. This works perfect, but, at the line ***foldername = .SelectedItems(1)*** it opens filebox and lets users select a folder to save the pdf file at, but is there a way to show the existing...

Hello All, I have the macro below that I was hoping to get some assistance on. Macro was working fine until I tried to both hide/unhide rows on the current worksheet and hide/unhide column on another worksheet based on response given in cell C24. Feel like it is something simple with the end...

Hi Why this formula is giving me 0 =IF(E2>50, ,) I thought it should give me True if E2 > 50 and False if E2 < 50 because I did not specify what would be if the condition is True or False. Thank you very much.

Hello, I have a VBA report I wrote. The report starts by Opening 2x CSV files Goal.csv (18MB) and Objective.csv (40MB) and copying their sheet contents to corresponding sheets in the report. The fastest now I can get the report to open is about 1 min. The open,copy, and paste process is taking...

I need to find a way to sort each line by Column A and then by Column D. The problem is that some events happened at the same time. The idea is to provide a timeline of each Incident Number in Column A. How can I get excel to know that if the timestamp is the same, the line that goes first is...

Is this correct? MONTH1_PDL: IIf(((DateDiff("m",[PDIR Due Date],Now()))>1) And ((DateDiff("m",[PDIR Completed],Now()))=<1) Or ([PDIR Completed] Is Null),1,0) I need the first condition met and only one of the next two to true [PDIR Due Date],Now()))>1 Needs to be True AND [PDIR...

Greetings Folks, I have tried to figure this out but I've yet to come across something that will allow me to make this happen. Every morning I have to open an Access File and press the "Run All" button which will do the macro that's found in the "Code" area. Is there a way that I can setup...

I have many checkboxes that I would like to move to a listbox to make things look neater in my spreadsheet. I have never used the listbox but I would like it to include all of my checkboxes with the option to choose multiple checkboxes. I know I must change the properties of the listbox...

Hi, honestly i have no idea wich formula to use in excel2010 - to solve this problem. I need to check if deposit 1 is equal with deposit 2. it is easy when there is only one value in both columns (row 1) simple deposit 1 =deposit 2 to give me true or fale value in the check column. However the...

<tbody> IN AM OUT AM IN PM OUT PM Return 1 1 1 1 TRUE 1 1 0 0 TRUE 0 0 1 1 TRUE 1 0 0 1 TRUE 1 0 0 0 FALSE 0 1 0 0 FALSE 0 0 1 0 FALSE 0 0 0 1 FALSE 1 0 1 1 FALSE 1 1 0 1 FALSE 1 1 1 0 FALSE </tbody> how to make the formula with that kind of combination then will...