xxxxx

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...

I have a spreadsheet where the data in column "D" today's date -1 (yesterday) and column 'J" has dates 1/1/19, 2/1/19, 3/1/19..etc. I need to add to the bottom of my current macro something that finds the first cell with yesterday's date in column "D" and with 1/1/19 in column "J" and select...

Hello, I have 2 sheets. Sheet 1: Sheet 2: Part # Description Weight Part # Description Price a xxxxx 2 b xxxxx 1.00 b xxxxx...

Here is what I would like to be able to do; Using excel I want to be able to import certain data fields, from certain text files, inside a certain folder, into certain cells on an ongoing updated spreadsheet, adding rows as I go. There maybe anywhere from two to 100 text files in the folder at...

Hello, I have a pivot table that I am struggling with. The back story is that I use Microsoft Dynamics GP and Excel Report Builder. The excel report is a refresh able report. This report is used to capture our EFT and Check information so we can submit it to our bank (so they can send out our...

Hi, I have an example of a table below that is retrieved from a web based platform in a .csv format. The problem I'm having is that the "Transaction Date" field can show 2 different formats (examples below) and neither of which are in a date format. They come to me as a European format, not US...

Hi, I have a number which goes like XXXXX/dd-mm-yy. What I want is that when this number is entered into a cell and then dragged down, the XXXXX part should get incremented by one number each but the /dd-mm-yy should remain the same. Is it possible...??? TIA