abc

Hi everybody, I have 1 excel file, 1 word file. I want to create 1 new word file like table in below. How can i do that with VBA/Macros? Thanks :) <tbody> INPUT INPUT OUTPUT EXCEL WORD1 WORD2 CELL1: ABC CELL2: 123 CELL3: 456 PAGE1: 11111111456111111111 PAGE2...

I need help showing a cell value from excel sheet onto the UserForm1 VBA code below is in my UserForm1 Private Sub UserForm_Initialize() Dim i As Long For i = 1 To ThisWorkbook.Sheets.Count Me.ComboBox1.AddItem ThisWorkbook.Sheets(i).Name Next End Sub Private...

Dear all Could you guy help me out with the VLOOKUP. below are the table i would like to use the VLOOKUP. <tbody> Num AC Name Num 1 11002 ABC 1 Apple How to vlookup Num and meet the criteria 42 of column AC then extract value of Name 1 11001 BCA 2 Orange 1 42001 Apple 3...

Hi I want to filter this table using Date. I do not want to see any date of year 2018. So what I did, select Data Filter -->between after 12/31/2018 before 1/1/2018 But excel showed 0 rows. I tried AND/OR same result I tried After 1/1/2018 Before 12/31/2018 , got same result...

I'm trying to work on a formula to get the 5 nearest transactions before the specified date. I've been able to draft the following formula Where Range for Dates in Source Table = $C$3:$C$50 Range for Names in Source Table = $D$3:$D:$50 Reference Date (Specified Date) = $F$1 1st Row for the...

In column B ther are Numbers from 2nd row to Last row. starting from 0001 in between in column B thereare numbers starting with "Z-" and these also respectively starting from 0001 but if i select in combobox "ABC" I would like to auto increment the number with String "Z-0002 in the textbox when...

Saw many different formulas for selecting cells etc but couldnt find an answer to my question: a) I need to select the whole Columns A, B an C (lets say), n have it copied to D (that is free). Then the contents will be cpied to D, E, F. Next time I ru the script, it must copy ABC and paste to...

Hi, I have a table [T_Run] with fields [TeamName],[ID],[RunnerCategory] Table is created with every runner's ID, teamname & runnercategory(ie, captain, runner2,runner3...) <tbody> Id TeamName RunnerCategory 255 abc RUNNER4 260 abc RUNNER3 354 abc CAPTAIN 52 abc RUNNER2 </tbody>...

I have an inventory spreadsheet where the supply item name is in Column D, Receipt Quantity in Column E, Issuance Quantity in Column F, Return Quantity in Column G, and Balance Quantity in Column N. What I would like to do is when I enter a supply item name in Column D and its balances, that...

Hi If I want to change a cell value then I can write this code sub abcthisworkbook.activesheet.cells(1,1).value =10 end sub but I can also do that by writing this code sub abccells(1,1).value =10 end sub I see both give the same result. I do not see any advantage of one on another except...

Hi, i have two excel sheet in same workbook. Sheet1 is having <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> A B Comapy Name Value abc ltd def comms ghiuniversal pty ltd jklquantas </tbody> </tbody> Sheet2 is having...

1.I am confused as to what [&] means does itdenote what is between the [&] is a string like: & this is a string & ? 2 If I want to put a formula in a certain cell like J2 to be (B2 – NamedCell) would I; DIM ABC as string ABC = NamedCell ; set ABC as a named cell Range(J2).Formula...

I am looking to see if anyone might have a macro for data that has blank rows inserted between data? For example beginning with this: <tbody> Column_A Column_B Column_C Column_D Colum_E Row_1 ALPHA APPLE ABC Row_2 BETA ORANGE DEF Row_3 GAMMA KIWI GHI Row_4 DELTA COCONUT JKL...

Hi excel expert, is there any formula taht i can use as per data below: Before <tbody> A B 1 abc xyz 2 3 4 5 6 7 8 9 </tbody> After <tbody> A B 1 abc xyz 2 2 6 3 4 abc xyz 5 abc xyz 6 xyz 7 xyz 8 xyz 9 xyz </tbody> when i put...

Hello I know I can do this Set myworkbook = Application.Workbooks.Open("c:\abc.xlsx") So I want to assign abc to myworkbook without opening the file. Is that possible? Thank you so much.

Hi, I have another question here that hope you can assist me. I have an extract of raw data from our bundy clock containing the clock in and out of employees per day. However, I am not sure how to put it in VBA - as I only need to capture the first and latest time (e.g for Name A - 6:21 and...

Hello everybody. I'm struggling with the following job. Looking for a cell10 value in rng1, if the value is present, then overwrite cell10 with the value next to the left relating to the found value in rng1. Example: cell10 = "abc" If "abc" is present in rng1 (suppose in cell C27), then...

Good morning, I'm hoping someone may be able to help. I have a list of invoices with amounts and applicable notes. Even though invoices and amounts are the same, there are multiple rows for each invoice because the notes are different. As a result, using the example below, when I pivot the...

Anyone How to to display the Following in XML with Following <co name=""><add1><add2><PHP> <a1><b1><city><Header>Co Name</Header> <Address>Add1</Address> <Address>Add2</Address> <A1> <B1> <customer>ABC Co</customer> <address>123 Main</address> <city>Salem</city> </B1>...

Hello, I have 100 GL accounts and each GL has the same list of projects, as example- six projects. I need to copy each GL account down for each project. Can you help to write a Macro to automate this process? <colgroup><col style="mso-width-source:userset;mso-width-alt:3876;width:80pt"...