original

Hi all, I would like to use a VBA code so that to split the col. “A” into 2, columns (“A” CODE, “B” DESCRIPTION), columns without affect the adjacent columns “C”, “D”, …. e.t..c . I present below the original data and expected result. Thank you all in advance <!--[if gte mso 9]><xml>...

Hi all, I would like to use a VBA code so that to “SUM” the rows from col. “B” to “N” if the left 7 characters in col. “A” are same. I present below the original data and expected result. Thank you all in advance Original data <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings>...

Hi. I have a macro which processes multiple workbooks copied into sheet2. I want to save the result in the same folder as the summarised wbs. Problem I'm having is that although all wb to be summarised will come from the same folder, that will vary so path will have to be derived from the copied...

Dear Sir I am using following code to save as file as cell value name, its working fine, I just need to be on same original file again after this code The original file should not be closed

I have the following formula and I want to drag it down 100 cells and have the cell references update and not keep the original reference. Is that possible? =IF(INDIRECT("'"&Reference_Sheet&"'"&"!A5")="","",INDIRECT("'"&Reference_Sheet&"'"&"!A5")) I want the next cell down to read...

Hello, I have inherited and frankenstein'd a schedule making spreadsheet. It has a mixed chart that has milestones, only, i can't seem to figure out why my milestone list won't populate the chart with the milestone names on the labels. I even copied in the original spreadsheet's chart and...

Hi there, I have copied and pasted number, but Excel changed it to another number. How can I retrieve the old value? The original value is: 2:2124 I should have copied it as Text. When I pasted straight into excel (actually google sheets on my iPhone), this value was stored as 37:24:00...

All hi, i would like to create a VBA code so that to run through col. "H" and where find a cell which contains the below break text, should make it to one line. Therefore that the break text is in same cell. In my below extract the "H" is the col. and "12" is the row. I present below the...

Good day everyone, need to pick your brains on a strange Access vbscript issue I am having. I have two dBases, one original and one modification of the original. I used all the same vbscripts macros from the original because they worked exactly how I need them. The modifications only include...

Hi All, I have the following data: <colgroup><col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3555;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2360;"> <col width="183" style="width: 137pt; mso-width-source: userset...

There is a workbook on shared location.. Everybody uses saved copy. Is it posible when the copy of workbook is opened to check value of SHeet1 in a1 cell (timestamp) of original closed workbook..and if the timestamp of original closed book is newer than create msgbox that says there is a new...

Hi, I am new to VBA. I would like to name the sheet in new workbook as Range("B2"). However, Range("B2") refers back to the B2 in original sheet instead of the new worksheet. The problem is when I apply filter for column B in original sheet and copy data to new worksheet, for example, the...

Dear Sir I am using following code and I have to mention location to save the file, is it possible that the vb code should save the file in same location as of original file, so I don't need to change the code in every computer. Sub PDFActiveSheet() ActiveSheet.ExportAsFixedFormat...

have sheet that contains data that constantly updates. need to do the following; when sheet opens, create new sheet with Date as sheet name, then copy values only from original sheet in A1 copied to newsheet A2. then if A1>A2 copy value only of A1 to newsheet A3, if A1<A2, copy values only...

I have found some really good info here about moving the duplicate values to another worksheet. Is it possible to move the original value with the duplicate. Example I have 6800 rows of data column D has member Ids. In some of the rows the member IDs are duplicated. Let's say I have starting...

you locked my original thread didnt know how else to get a hold of you

Hi all This is really foxing me and I'm hoping someone can help before I pull all my hair out! In 2013/2016 creating a new workbook will leave the focus on ThisWorkbook even though it is the ActiveWorkbook, and I cannot seem to get around it. The reason this is causing an issue is that in...

I have a workbook with three tabs Original - The original version of the data New - The same structure but with update Results - Id like this be a macro that uses a key to the values in each row and the new rows not in original an the rows from original not in results

Hi, I had locked excel files using LockXls utility but unfortunately I misplaced my original excel files. Does anyone know how to restore the original files. If I use their utility to decrypt, they want hardware id that I don't have. Thanks

Hi all, kindly advice me for a VBA code so that, to run through col. “H” and where find the descriptions “Trade union 1” and “Trade union 2” should insert rows below and also should divide its amounts in col. “J” by 2 and place them in the inserted rows. Descriptions in new rows should be “Trade...