content

i have a file written by another program, but changing the file's extension to zip, i could view the contents of the file. Is it now possible to extract a specific content from that file without changing the extension using vba? Actually the content i want to extract is a picture file and i want...

I'm using a bunch of sheets like forms and pulling the values to the main sheet with =INDIRECT(E1&"!b2") where E1 is the sheet name I would like to add comments to the same cell from the corresponding C cell Ie. cell content =INDIRECT(E1&"!b2") cell comment =INDIRECT(E1&"!C2") Is there a...

Hi everyone, I have a dataset in which the top row gives me the days of the year and the cells below contain a formula giving me the name of a promo that covers a certain amount of days. The result is a dataset in which every row has a certain amount of contigous cells containing the same...

Hi All, Im sending an email from excel using some sort of formula. In my body of mail 1st I have some content then few pictures then followed by that some content and below that I have a textbox in which I have a hyperlink. Im successfully able to paste the entire content in email and able to...

Hey guys, so I'm currently on an internship for a major tech company and they've lightheartedly said that if I fix a specific IT issue, they will give me a job there. ...However, in order for me to fix this, I need to manage a tremendous amount of data and sort it in a very specific...

I need to create a product label concatenating the content of several cells... Now, some of them can be empty and other not... Let's imagine that I have in a cell the result of several other cells, concatenated... A1 contains "" or could contain a value B1 contains "" or could contain a value C1...

Hello I have 2 sheets in my workbook. Basically it is an external and internal version of the same content. All information on the external sheet is linked by formula to the corrosponding internal version. So in A1 on external version is a formula linking to A1 on external version. Both cells...

Hi, Apologies if this type of solution has been posted elsewhere - I have been attempting to use a variation of the solution provided under https://www.mrexcel.com/forum/excel-questions/873522-vba-copy-paste-row-while-replacing-2-cell-values.html What I'm trying to achieve is having excel look...

Hi VBA Gurus, I would like to copy text or paragraphs between two headers from docx to xlsx file. 1. The VBA script needs to run from excel using Early Binding technique (referencing to Object Libary) 2. The two headers will always remain the same and will never change. 3. The code needs to...

This all content are in only one cell. i want to give multiple hyperlinks in single cell for each individual content.There are 10 pdf files in my folder..i want to open them by clicking on individual content <tbody> 1. Our Lr. No.Nil dt.06.04.2018 2. PD NHAI Lr. No.NHAI/PIU-SR//NH-...

Hi, I have an excel file with two sheets S1, S2 (please see below for sample content). All sheets are in one excel file. For each cell in sheet S1, I have to check whether there is/are an/multiple entry/entries in sheet S2. If there are entries, then I would like to count the unique types and...

Hi, I have a macro-enabled workbook with a calculation table These are the steps I need help with. 1. I wish to copy the sheet of a downloaded workbook, however, the workbook is "$XXXX" but when you enable content it changes to "Book1". Ideally I want the original workbook name as it is...

Hi All, I have another question. I have some code to automatically enter a password (linked pw protected docs) in multiple times when using my update links macro. It works fine. The issue I have is sometimes when I open the document it asks me to enable content which I then have to manually...

I have a table in the range B4 : N1004 . Column E contains values and F contains Dates. And G contains values and H dates etc to N . I am looking for a script that will look at column F for dates other than today's date. Cells that don't have today's date, clear that cell and the adjacent...

Hi, Can someone please help me with a VBA code for the following: 1. Suppose I have around 1000-2000 email ids in Column A 2. I need to assign content for eg. "Car" to half of these ids in Column B and "Motorbike" to the other half. Appreciate any help!

I am looking for a way to automatically change the color of a row based on the content in a specific cell. For example: - the default color of any row is white - if content is added to cell A2, the color changes to red - if content is added to cell B2, the color changes to green - if content is...

Hi friends, I want to add a new row to my table "Time_log" based on if there is any content in the second to last row of the table (the very last row is my "totals" row). I want this to trigger whenever someone adds content to the second to last row, so that it make a new row available for more...

Hey, I’m in need of someassistance. I have a formula in place at the moment which is automatically copyingthe contents of a range of cells and inserting them all into a single cell on aseparate work sheet. I want them to copy on separate lines so the formula Ihave in place is: ='DOCUMENTS...

Hello my friends! I have an userform that records the same content at two Worksheets (Worksheet1 and Worksheet 2). Whenever I need to erase an entire row content, I select a cell, click at trash can icon and it runs this code above: Sub EraseActivity_Click()...

Hi All, This is actually a problem that is effecting not just Excel but all office. I am trying to embed the content of a PDF into the workbook - I totally understand that I will only get the first page of the document, thats all I want as the PDF is always one page in length. I am using...