xxxxxx

Hi, I have the below tables and I am trying to match back avalue from a separate product table & then output a calculation dependingon the value found. I have the below formula which looks fine to me but I cantfigure out why it only returns a 0 value. The formula should find Product...

First, apologies for vagueness as I don't really know how to approach this. I am exporting reports that are providing customer info that I need to consolidate into single lines. Unfortunately, the export is designed in a pdf/printable report format. The objective is to copy updated data into an...

Hi all I have folder with a lot files like: xxxxxx-yyyyyyyy-zzzzzzzz-wwwww-aa-b-cc with extension: .xlsx .xlx .rpt .doc .docx Please help me with macro VBA to do that: 1. Brown to folder and get all files full name include extension: .xlsx .xlx .rpt to sheets("data") begin from range ("A2") 2...

I am researching my Great Great Grandfathers time during the Civil War. What started to be a simple Excel file has grown to a large file, 25000+ rows. Not what I planned for but the further I got in the research the more I expanded to included all members of his units. I am new to VBA and...

Hi All, need your assistance on creating formula to get specific number in cells. Currently i have many rows, please see sample below, each id has 11 characters and can be start with 10000 or 20000 <tbody> Description ID (expected result) please use this id 10000428271 to fix this issue...

Hi We have job requests that come in a specific format. Most of it is fine, but we would like to change the start and end dates to include the days of the week. The current format is; Ref: HH65161651 Job role 12345 | xxxxxx xxxxx site xxxxxxx Rota: 21:00-09:30 238073 From - 18/01/2019...

I have this and I need to get the first and last name out so I can use them for a vlookup please help Richard XXXXXX 1993446666 Tom XXXXXXX 1993444444 I am using this =RIGHT(G7,SEARCH("",G7,10)) but I need to use the name now

I am not much good at this and any help would be appreciated. I can’t drag formula down column. =Sum($E59:E164)/105 =Sum($E59:E165)/106 Note division is Ascending by each entry Drag gives: =Sum($E59:E164)/105 =Sum($E59:E165)/106 which is correct...

Hello everybody. I need to schedule a macro for 13/05/2018 at 20:00 In this workbook, I have to write something like this: Private Sub program() Application.OnTime TimeValue("20:00"), "xxxxxx" End Sub But: 1) how can I add the date? 2) could the date format be a problem? Of course, the...

Good day to you all. As the title implies, I would like to copy entire row and paste it at the SAME WORKSHEET below the cell that contain specific word. For example, <tbody> A B C XXXXXX ABCDEFG/123456 YYYYY </tbody> I would like to change the above table to : <tbody> A B C XXXXXX...