ghi

Sheet 1 <tbody> ABC 40 DEF 25 GHI 35 XYZ 20 </tbody> Sheet 2 <tbody> ABC 45 DEF 20 GHI 10 PQR 18 XYZ 40 </tbody> I want changes in value in 3rd sheet based on name criteria match of both sheet and additional name and value of sheet 2. Could you please solve my issue.

I've been toiling with this one for a few hours and have decided to come ask the experts for help. I'm trying to capture the start date associated with a particular company (in sheet 1) from a list of many stages that each company goes through (sheet 2) Sheet 1: unique list of company names...

I am trying to sum up stock that was received in a given month to each individual location. I can't do a vlookup because the same item might hit multiple locations and not give me the correct quantity received in at that location. I have two separate worksheets. One worksheet is a summary of...

Hello Board, Here is my dilemma. I am trying to populate column H with the MAX date from column C where: item code matches (A=G) D is blank If no items in D are blank, make zero. (I will conditional format so it's blank and not 1/0/1900 if I need to) Note, this table A-D will NOT be...

<tbody> ABC - DEF - GHI - JKL - MNO ABC DEF GHI JKL MNO ABC - DEF - GHI - JKL - MNO ABC DEF </tbody> Using SPLIT with a "-" delimiter gives the first output above - is there a way to limit the command so it splits ONLY the first two parts? Thanks for your help!

i created a pivot table as below. in my table i want to running serial number of every row as sequence wise. Date: 00-00-0000 (report filter) ROW NAME LCB CB VCB LMDF 1 ABC 10 05 15 20 2 DEF 09 12 21 10 3 GHI 15...

OK real simple one I just can't think how to do it... I have a column A which is where I want my numbering to count up Column B has company names In All the company names are In order but there are multiples of the same company name so: Abc Abc Abc Abc Def Def Ghi Ghi Ghi And so on...

Hello All, I am looking to improve the output of this small VBA code below. At this point I can copy and paste values without being a table in Word (Unformatted text). Keep in mind the example shows only 3 cells, but I am looking at over 40 cells over a few worksheet. Now I want to add a...

Hi Team, I have a bunch of data in a table that I need into a column set up as per the below. Base Data <tbody> QWE ASD ZXC RTY ABC 10 20 30 DEF 40 50 GHI 60 70 80 JKL 90 100 </tbody> Formatted Data <tbody> Head 1 Head 2 Head 3 ABC 10 QWE ABC 20 ZXC ABC 30 RTY DEF...

Hello I need a formula to bring info over to another sheet with 3 unique identifiers: Data on Sheet 1 - (Where the formula will be copied into to populate data) <tbody> Org Number Class Type Funding OGH 217 11.23 18659 GHI 217 11.45 18659 SMI 217 11.36 78659 OGH 217 12 18648...

Hi, I have a sheet, with a dataset which is 18 columns, however, further datasets of 18 columns are repeated throughout the sheet horizontally. I need to stack this data vertically. below is a crude example of the table i have and what i need to do is take all the data outside of columns a...

Question... I am trying to write a macro that takes the Value in B1, finds B1 in row 5 and pulls in the coresponding data in E1:F3. I would just put in an index match match but the data prior to the current week has to be able to stay without getting deleted. Any help is greatly appreciated...