content

I'm looking to enhance my conditional formatting to highlight the cell in column C if the content is not an option from the drop-down fields specific to another cell. My spreadsheet has two columns with different drop-down fields. Column B is the subject and column C is the Type, below is an...

Hi, I am importing worksheet from an excel file in access. When I try to import excel file. I can see below message. Both the excel file and access files are saved on the same path but in a different folder. Excel file does not have any formulas or hyperlinks. Pop-up is as below A potential...

I have a workbook in Excel 2010 that after I use a sort macro when anyone reopens the workbook we get an error that says it has unreadable content. Then if you say yes we see a box that says. Removed Records: Sorting from /xl/worksheets/sheet1.xml part I never seen tis before until just a week...

I have a spreadsheet sent to me with various data I need to separate into two chunks of data and copy each to another worksheet. I am stuck trying to get the end row of the first range and the start row of the second range. I would prefer them as two separate subs if possible. That makes it...

Hello guys, I am trying to create word documents based on an excel table as follows: <tbody> Word doc 1 Word doc 2 Word doc 3 Line 1 Yes Yes Line 2 Yes Yes Line 3 Yes Yes Yes Line 4 Yes </tbody> At the end this creates 3 documents and each one has only the lines with Yes...

hi all a parameter of the SUM.IF function is: Criteria work for me if the criteria is A5 (Note in AA5 the content is: '95') but i want have in A5: 80,17,45,95,76 i want sum if the criteria is in.. in this case 95 exist in the list. understand me? thanks.

So, I want Excel to go through each cell in the column I and if the length of the cell contents is more than zero, go through the next lines and change the content accordingly... but if the content is not listed and still the length of the current content is more than Zero... just change it to...

Hi and thanks in advance! I have a range of cells "X3:AB28" named "NeededPicture05" then within the cells B6:E12 I have a foto of this range, but no matter what I do the range of cells B6:E12 does not show the full content of what I have in X3:AB28 range(""NeededPicture05"") shows a few...

Hi, I have a column of cells with numbers and text. I would like to strip the numbers out, but there is a character at the front and one at the end of the cell content e.g. (*123.4p and *12.4506p) The additional problem is that the cells have different length of numbers. Any help would be...

Hello , I need a script for some task: I have a list of items in a range say A2:A50. I need a script that when I run it, it will change the cell B2 to the value in A2 then A3 in that order till I get to the last cell in the range A2:A50 that has no value. The cells don't have any formulas. I...

This is probably not possible, I am on a Mac with multiple versions of MS Excel (including the latest version). I am trying to move the content of cells up into the blank cells based on a range of selection. I know I can select a range and then press F5 and choose "Special..." and choose the...

say, I have a table of content sheet, with the listing of the sheet names - and there are other sheets say sh1,sh2 sh3 etc how would i make other sheets to appear whenever I click their number? and return to the table of content as soon as I exited from them how would the vba macro look like Thanks

I'd like to create a macro that would paste clipboard content from notepad (text) into cell A1. I've found some examples online however mostly for the other way around (cell to clipboard) and I can't seem to turn it the right way. Thank you.

Hi everyone I am using Excel 2013. Please is it able to change the multi pages in different back colour? Also I have several long user forms and how can I have the full content print out without the scroll bar? When I print out the long user form, it only prints out the screen content and...

All, I have a sheet that contains content in the first/odd rows from A1 to M1. The second/even rows have content from A2 to C2. I wish to transpose A2 > N1, B2 > O1 and C2 >P1. Any help would be appreciated...

Good All below code to format individual character it works but does not work with last format so I added 1 total cell content (Len(TXT)+1), but not useful thanks Public Sub TXTFrmt() Dim WB As Workbook: Set WB = ThisWorkbook Dim WS As Worksheet: Set WS = ActiveSheet ' WB.Worksheets(1)...

UDF need to lookup cell content for city, state names from sheet2 ColumnA Please see the example link https://docs.google.com/spreadsheets/d/1Qw0CaBUP1Qo0uaXRO-jlKdT6wJu5xfhrs84QGBzFlLs/edit?usp=sharing

Hello everyone, I have spent quite a lot of time trying to figure this one out. I have excel with bunch of data, and I need to show data which is based on filtering. I need to, based on one data column, show filtered content of another column. I can do this manually, but data source is...

According to this article: http://www.snb-vba.eu/VBA_Dictionary_en.html what is the difference between section 5.2: With CreateObject("scripting.dictionary") .Item("first") = "content" End With and section 5.4 Set dict_snb = CreateObject("scripting.dictionary")...

Hello , I have multi text files in one folder for example log001.txt log002.txt log003.txt I want to copy the content of these file in one work sheet so first file content in A and second file content in B and third file content in C etc..