universal

I have a macro to copy and paste a table from one sheet to another. I used macro recording to get this VBA: Sub CopyPasteNew() ' ' CopyPasteNew Macro ' Copy table from "New Term Deal" to Active/open sheet ' ' Sheets("NEW Term Deal").Select Rows("3:27").Select Selection.Copy...

hello all, I am currently working on a web site with a description column that cannot exceed 75 char. The data I have exceeds that in certain circumstances. Is there a VBA or formula you all know that will do this: Read cell content from right to left. Stop at the 75th character then cut all...

Hi Everyone, I am looking for a formula to extract the amount for each of these cells. Any help would be greatly appreciated. Sample: <colgroup><col></colgroup><tbody> UNIVERSAL 1420449 WASHABAUGH $55 11/21/2018 UNIVERSAL 1420449 WASHABAUGH $76 11/21/2018 UNIVERSAL 1420450 WASHABAUGH...

Hi All, Thank you for viewing my post. I am having difficulty with the index/match function. Below is an extract of my table (I had issues uploading the table via the normal channels). <tbody> A B C D E F G 1 Local code Age Universal Code Local Code Age Boundary Universal Code 2 TUCEG...

Hey everyone, I have been looking online for the location of the date picker but all I have seen is that with 2016 64 bit versions of excel its a no go. Is that still current or has it been added. I have seen some addins but it is for a shared worksheet and if possible i would like to find a...