xxxx

Hello, I'm quite awful at VBA and am trying to make a macro that does this: <tbody> E F G H I Item# Item Name Qty Total Tracking 1000 xxxx 2 xxxx 1000 xxxx 1 3 xxxx 2000 xxxx 1 1 xxxx </tbody> For this format, with the letters on top being default excel columns, I am trying to have...

Hi. I hope someone can help me. 1. I need to get the specific amount next to the word Principal For example: A1: bla bla bla xxx xxxx blabla bla bla bla blaPrincipal:1,000 xxx bla bla xxxx xxxx xxxxx bla bla bla 11/14/2017538.95Interest and bla bla bla Basically, all of the data are pasted...

Hi! I need help with my excel worksheet. If I write XXXX in column A - YYYY will appear in column b. Is that possible?

I need to look up the sup total or Over time based on the name. Example i want to put Doe, John in a cell and have it bring me 0.77, any ideas? <colgroup><col><col span="4"><col><col><col span="3"><col><col span="3"><col><col span="2"><col></colgroup><tbody> Pay Date Pay Code...

hi all, i have my formula in cell original, but i want to change and run in macro now. unfortunately it exceeds over 255 limitation of array formula in macro...

Hi, I have Data Sheet of a students, in which serial number and name of each student are given together in one cell. Is it possible to add only serial number of all? <tbody> ABC School Class VI Students 1 xxxx 2 xxxx 3 xxxx 4 xxxx 5 xxxx 6 xxxx 7 xxxx 8 xxxx 9...

Hi all I need help to take value of Cell that: with j = 2 to lastrow if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R101" then copy value in Cell(i;C) to Hj if Cell(J;G).value = Cell(A2:A).value and Cell(i;B).value = "R102" then copy value in Cell(i;C) to Ij if Cell(J;G).value =...

<colgroup><col span="3"><col></colgroup><tbody> NUMBER NAME HOURS HIGHEST HOURS 9999 XXXX 23 54 6577 XXXX 43 66 6577 XXXX 66 66 9999 XXXX 22 54 6577 XXXX 53 66 6577 XXXX 23 66 9999 XXXX 54 54 6577 XXXX 65 66 9999 XXXX 22 54 </tbody>

Hi All, Some advice from a more learned soul than this aging chef please.... I have a welcome message that pops up on opening a work book: "GOOD DAY and WELCOME PLEASE NOTE: IF YOU HAVE NOT PURCHASED AN OPERATOR AND OWNER KEY YOU WILL NOT BE ABLE TO ACCESS THE PROGRAM ON THE EXPIRY OF YOUR...

Good Evening everyone! I'm trying to configure a VBA Macro in excel that will import the body of emails into separate lines. Mostly concerned with getting the link between Outlook & Excel working. I have some novice experience with VBA, but this is proving much trickier than I anticipated...

Hi, I need to split a cell into columns where the data is imported in 9 lines with each line being its own subject such as the below. Each line should be its' own column. Time of call: 17:17 Category: Dogs Subject: Lost Dog Caller: Mxxxxn Mxxxxxy Phone: 0xxxx0xxx4 Address: 3 XXXXXXXX DR ...

Hi Experts! Here's my current situation. And I would very much appreciate the help :) I have 4 different worksheets. Let's call them: Sheet1, Sheet2, Sheet3, and Sheet4. The first 3 contains data that is delivered daily. Sheet4 is meant to dump the raw and compiled data between the first...

Hi, I need some help. I have a list of information provided and I need to copy a specific range and paste it into a new sheet RC 1 xxx xxx xxxx xxx xx xxxx xx xxx xxx RC 3 xxx xxx xxxx xxx xx xxxx xx xxx xxx RC 2 xxx xxx xxxx xxx xx xxxx xx xxx xxx the 1 / 3 / 2 might not be...

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

How do I amend the code in IF(ISNUMBER(SEARCH"XXX" ...etc so if it ISNT "XXXX" please

Hello Folks. I used to export tables in PDF to excel. Sometimes all the words in the columns saved as a single cell. This cell is always the last used row. Each word is separated by space and Dot (.) in their respective columns. Now i want to move the words downward in their respective columns...

Hello, I would like to run a search and find cells in my column A that contais the following text: "account - xxxx - services". Then I would like to extract these "xxxx" value from the cells in the original sheet and place it in cells in another sheet. Thank you, Karen

Hello, In cell K1 of sheet1 I need to have the wording 'Final Price from xxxx' The data I need to enter for xxxx will change each week and should reference cell C1 from the LastWk worksheet. At the moment the below code is failing; ActiveCell.FormulaR1C1 = "=""Final Price from""&""...

Hi All, Please help me on below requirement in excel. If i maintain any value on NAME cell any one of (Father name (or) mother name (or) guardian name cell value should be mandatory. <tbody> Name Father name Mother name guardian name John XXXX Sunny XXXX </tbody> Many Thanks...

hi I have 2 Excel files. 1 Source and 2nd Destination. There are some columns in Source file like <tbody> Sr No Name Address Contact no 1 Abc xxxx 123 2 Xyz xxxx 345 3 Mno xxxx 567 </tbody> and in Destination there are below fields <tbody> <tbody> A1 Sr No A2 Name A3 Address A4...