side

In Excel I can perform a lookup that uses the desired column for the return value by varying the column in the formula. How can this be done on either the Query side or the PowerPivot side of PowerBI?

I'm trying to produce an excel chart to show responses to a survey from two different sources. e.g. What trends do you think are permanent or temporary? Apples - P,T,NS Pears - P,T,NS Now there are results from a National survey and then results from Local survey. The options people select...

Hi, I am after abit of help which is above and beyond my excel skills. I have two spreadsheets lets say called "SheetA" and "SheetB" Sheet A needs to match the "username" in column B to the username in column B on the other sheet (Sheet B). If the usernames match then I need it to copy the...

How can I create a single sheet or form that just shows the single sheet? In other words I don't want to see the normal unused columns on the right hand side. It would look like the print preview w/o the RHS cells.

Hello, I need a VBA code that will simply do a side by side comparison (meaning I want it to check if cell A1=B1, A2=B2, A3=B3, etc). If it finds a difference highlight the cell. I know you can do this with conditional formatting, but I would like to do it via VBA if possible. Thanks.

Hi all I am trying to get the shapes.AddPicture function to work. I have tried two methods of input which from my searching should do the same thing, granted I am new to VBA so I may be misinterpreting. Any help would be greatly appreciated! first method code: With...

I have some named shapes on the active sheet - let's say then names are "28", "28+31" and "31". They have got their names from some LONG PId's in my Access DB - never mind that ! "28" and "31" are in fact som ractangles and between them - a little lower on the sheet - is a triangle - this...

Hello, I looking to create a standard header for my team's documentation process and we will be 3-hole punching our documents and placing into a binder. For worksheets that print in "Portrait", this is no problem as we put the header at the top and then the three hole punch goes on the left...

I have a detail table that shows monthly salaries by month across the top and individual staff members with department down the side . I'm creating a summary table that counts the number of staff in a table by date across the top and department down the side (salary greater than zero). I've...

My skills with VBA hasn't been used in many, many, years now, so I am totally lost on this project that I am doing. I know my VBA code is rudimentary and there are far better ways to do this than what I have done so far. So please don't flame me too bad on this :). I have managed to get what...

Hi all, I hope I can explain this properly I'm after some ideas/formulas which will help me create a status tracker. Background - customer data will have max 6 status depending on where they are in the life cycle. (all customers have a unique identifier) Weekly data will be provided with...

I am looking for the code which will extract the string from right side of the worksheet name up to first space in entire string and paste it in cell B11. Example of the string (worksheet name) : my sheet.1 - 31111111C --------> result in cell B11 should be 31111111C for that I have code...

Hi, I want to eliminate everything in left after a word. Example: Suppose I have below number a) 123 # 456 b) 12 # 21 c) 1234567 # 7654321 The output which I require is everything after #, as : a) 456 b) 21 C) 7654321 Could you please help? Thanks in advance.