side

I am trying to create a conversion tool for data I get in a PDF. I have a rows worth of data that all shows up in the same cell when pasted into Excel. I am trying to use formulas to separate the data to make the process repeatable in an easy fashion. (Paste into sheet 1, auto converted copy...

<tbody> FROM TO SIDE TYPE 0 20 LHS PQC 20 30 LHS DLC 35 50 BHS PQC 65 67 RHS DLC 68 70 RHS PQC 71 77 BHS DLC 88 90 LHS DLC 91 95 RHS PQC 95 98 BHS PQC </tbody> In above table I want to do made VBA code as requirement below. First sort the rows Heading "TYPE" and then sort by...

Hi guys, I'm trying to automate through vba a script that will follow a list of hyperlinks to Google search results and to copy the phone number listed for each link (phone numbers in google searches are listed on the right hand side). Example link showing the phone number on the right hand...

I have several columns that contain formulas in the cells- One Column (right in between several others) will not take the a formula. It insists on displaying only the value of the formula. Might be the weirdest thing I have ever seen in excel. All other columns (Left Side & Right) side...

Dear Friends, A: I have a worksheet of " Offshore Weekly Crew Change of Staff". I have all names (40 Names) in the left most column with validated (Drop down list). I need an Excel function to take any value from the left side validated drop down value and bring the corresponding ROW vales at...

Hi All, I've searched the forums for this but cant seem to find a solution. I have multiple worksheets in a workbook, each worksheet has around 7 or 8 columns and the number of rows vary in each workbook. i'm looking for some vba code that will merge the columns next to each other rather than...

I think I came across a cool workaround for gluing connectionlines to the corners of a rectangle. The normal connection points are in thecenter of each side. I wanted connection points at the corners. Using Insert Shape, I drew a large rectangle whilezoomed out to ~10%. I then zoomed into the...

Hi, New to this, but have tried this: Two workbooks open side by side in the display. In a cell in a sheet in one workbook, I type an '=' sign. I then click on a cell in a sheet from the 2nd workbook, and press Return. Nothing seems to happen. No formula referencing the cell in the 2nd workbook...

Need to run a loop that takes data from one sheet and put the data onto another. Sooo on the new sheet C3=B5 D3=C5 E3=D5 F3=E5 C4=H5 D4=I5 E4=J5 F4=K5 C5=N5 D5=O5 E5=P5 F5=Q5 ... C16=CN5 D16=CO5 E16=CP5 F16=CQ5 Left hand side is new sheet and right hand side is like worksheet1 All in the...

Hi All, I have tried to get data by using an excel formula. But I felt. Actually I want to generate data distribution from down row to column wise and right side. Suppose, I have some data in row 1, 2, 3 and 4 by an household ID of that household's all 4 members. Now i want to take all...

I have a spreadsheet with 20 charts, each comparing one of our products vs similar products from our competitors, as well as a map for each competitor. The charts run along the right side of the spreadsheet with the map on the left side. A drop down menu allows you to toggle between maps. The...

Hi everyone, I've got a problem that is very straight forward that is beyond my abilities. It is as follows: I have a sheet that tracks all expenses and info regarding them (Date of expense, check number, expense item, dollar amount), where all info regarding a particular expense is stored side...

Hi All, I'm looking for assistance with a modelling question that I've hit a few times in Powerpivot: displaying only *related* row labels from the many side of the relationship, as a subordinate row label to the "one" side records. I have an example model screengrabbed that I think makes the...

Hi, I am a Excel Graph novice. I'm hoping this is simple. In Cell B5 I have a figure of 800. In Cell B6 I have a figure of 200. I want to put this in to a Column/Bar chart but show just one Column. So in total it goes up to 1,000, but it is split in to two amounts. One of 800, one of 200. In...

Hi, At the top of my page i have this: <colgroup><col width="220"><col width="152"><col width="157"><col width="118"></colgroup><tbody> Highest Rated Player (Available): Beestin, Alfie Attacking Midfielder 500 </tbody> <colgroup><col width="220"><col width="152"><col...

Hi, I managed to make myself a graph that shows each month (Jan18, Feb18, Mar18 etc) but can I change it so the months are reversed? ie the latest month is on the left hand side. I tried to change the order of the data to newest to oldest but it doesn't change on the graph. Hope that makes...

I have a sheet of 324 columns and 72 rows. I want to copy specific columns from sheet and paste them side by side in following manner 1,12,24,36,48.....(multiple of 12..... upto 324) side by side in new sheet1. then 2, 13, 25, 37,49(multiple of 12+1)...upto 324 side by side in new sheet2. then...

Hi , I have three columns like Inside/Out side Fixture description replace fixture Inside here is drop down list of fixture This column gives you the drop down...

I have tried to look for this in the existing posts but I'm not really sure what to search for. Due to restrictions as at work I'm looking to solve this with standard Excel formula and not customs or VBA. The data that I have is variable, the number of data in the cell against each month will...

Hello, I have a problem on my pivot table, when i add several fields in the columns they are display with a strange way. And i would like it to be like this. How can I do ? Thanks.