reads

I've got an eleven page doc that all of a sudden has 6,941 pages. I only noticed it because the footer reads "Page X of 6941". How does this happen and how do I change it??

Any help on this would be greatly appreciated. I have already tried recording a macro but to no avail. I have a wkbk with 6 sheets, and each one has a date corresponding to the data in the form of 2019:129:14:18:31.274 YYYY:DDD(day of the year as in 129th day):HH:MM:SS.sss I would like to turn...

Hi all, I'm befuddled on how to write a code for VBA that takes a "Data entry" user form with Comboboxes named, "cmbname" from there to the designated next empty cell downward. Also, if there is a code that reads the column for any duplicates and lets you know that there is already a name of...

Hi, my worksheet has a date manually entered in A1, I use the formula =EDATE(A1,6) to project the date 6 months ahead in A2. In A3 I manually enter “pass“ of “fail“. I would like the date in A2 to only be projected if A3 reads “pass“. Thank you very much.

I need a formula for cell Q8 that looks at cell E8. If E8 ispopulated, place an x in cell Q8. If itmakes a difference, cell E8 has a formula that reads from another tab withinthe same spreadsheet. Thanks in advance

I can convert a column of data to type: text. But it still shows large numbers as scientific notation. For example: in a cell it reads: "6.40001E+14" but in the formula bar it reads: "640001171111044". I need it to say the latter, as these are Serial Numbers, and no math is being done. What...

Hi I have 3 macros assigned to 3 different shapes (buttons). Each macro does exactly the same thing (enters text into a cell), but for each macro its different text. Is there any way I can have one macro only for each button but the macro reads the text inside the shape and uses this as the...

Hi everyone, I am in need of some assistance. I am trying to determine how many working days in a given month within a given year are available. I know we can use the networkdays function, however I have some constraints that i need help working around. I have 2 rows, the first row reads the...

Hello, I'm trying to categorize a number in a cell for example 4557808818 the formula I'm tying to write is =if(left(a1,1=4),"airbill",if(left(a1,1=5),"online" etc. what is the correct format o write this so it reads the first digit f a string and categorize it? thanks

I have been using Excel for years. but i hate if statements and im very bad at them. A1 is NO A2 is NO A3 is NO (The "NO" is a data validation list value) The equation reads =IF((A1="NO" & A2="NO & A3="NO"), 555,0) I keep getting Zero instead of 555. Argg. thanks for any help

If I have the following data set: .....A... 1 2.9 2 0.7 3 -0.8 4 -2.5 In cell A6, I want to sum all of A1 thru A4 and average it out =SUM(A1:A4)/4 but...when I add another row of figures at the top of the set and delete a line of figures at the bottom of the set, for example, now I have...

Hi guys, I am currently trying to make a document for work and I am a little bit out of my depth. I'm hoping someone may be able to point me in the right direction or to tell me if what I am trying to do just isn't possible. I have created a data profile which works fantastically well using...

macro needed in cell P2 I want to count the positive numbers in col AK (starting row 19) If col D reads "cap" thanks ironsides

People Could someone help me out with my countifs problem. I'm trying to count where in col AM the string reads 'Dog' that the corresponding cell in columns BA:BB reads 'Yes'. I've fannied around with this for an hour or so and even tried searching old posts. To no avail. This is my doomed...

Hi all, Novice at VBA here and need some help adding an extra element to my current VBA code. So, I created some formatting code that I have stored in a separate file and whenever we need to make use of the VBA code we open the file and use the shortcut I associated with it, in this case...