needing

Hello all not sure if what im needing is quite possible. Im needing a Macro to Sort a range and Print it without haveing to Sort the actual excel. Just need the Sorting to occur for print purposes not to effect the actual excel.

Is there a way to check if a file is open but without the path, in other words, if I have a file text.xlsm, how do i check if it is open without needing the full path like c:/text.xlsm, just test.xlsm?

Link to sheet: https://docs.google.com/spreadsheets/d/1nZs3it5lLQm8onE7KPP-RYfpnpeKivNQMtRvcrYqxmM/edit?usp=sharing I am needing to finish the pay sheet for my sales staff. I am needing to return a certain value in column R if 2 different cells have specific data and needing to return a...

Hi, Hope someone can help. I a looking for formula to help calculate charges to a client based on a sliding scale. EG For =5 hours, charge £30.00ph For 6-10 hours, charge £29.50ph For 11-15 hours, charge £29.00ph or 16-20 hours, charge £28.50ph For 21 + Hours, charge £28.00ph So, for a...

Hello, I recently purchased The 54 Greatest Excel Tips of All Time and I am needing the files that go with it. I can't seem to locate them with the information from the book. I appreciate the help.

Hi, I have a couple of examples, that need help on separation. In Column A, I have: Mystique - 2'6" x 8' Runner In Column B, I am needing the desired result of: Mystique-2'6"-x-8'-Runner There are some also, that contain a different variation, such as: In Column A, I have: Mystique - 18"...

Hi, about a week ago it seems that when I add a new custom column in Power Query it's defaulting as a VarChar type when the values are and always have been numbers. So it means I'm needing to add additional steps to transform the column to a decimal number. What could be causing this? Pete

I am needing help writing VBA code to export an excel table into a new workbook. I am needing to be able to export columns by name instead of by a range because the columns are not grouped together. I also need them as values in the new workbook. Any help would be greatly appreciated.

Hello, I am trying to use VBA to Export the Module from a Personal Macro Workbook and Import that file into the Active Workbook. I have seen a few that work when it is workbook to workbook but I cannot get them to work from PMW. I am just needing some help. Thank you :) I didn't put any code...

I am needing some help with my attendance sheet for my new team. The sheet has 4 types of absences on it: Vacation, Float, Flex, Military. The sheet has 3 columns: Date-Type-Hours Used I also have at the top of my sheet 4 columns with the hours allowed for each type, and a box with hours...

Hello, I'm needing help figuring out a way to tweak a formula that I use on a spreadsheet at work. I use the formula below to track active unique projects and it works fine as long as my only criteria is not counting blanks...

Howdy- I'm needing some help with something i'm not sure how to do. I have a 2 cells (text values) that has names (i.e. Bob and James), i am needing a way to have these values swap each week for example. If this week E5 is Bob and C7 is James, i need for it to next week automatically switch to...

I am looking for a VBA solution to limit the number of cells that can be copied at one time within a workbook. The data contains emails and I am needing to secure them to where only one can be selected at any given time. Any solutions?

I'm needing to create a formula to check two columns. I'm needing to check following... if the first column has an A, then the second column should have a 1 or 2; if the first column has a B, then the second column should have a 2 or 4; if the first column has a C, then the second column...

Hello, I have the following code which currently works perfectly and in a timely manner, I have had to add a filter in to ensure that any row that contains the word "testing" is not removed even if the adviser is on the list of not needing a check. this appears to have slowed down the...

Hi all, Needing help I am not a super excel user but just wondering if someone could help me with a formula to extract data from a pivot table. I currently have a formula that works by matching and picking up data but i am trying to pick up data from 2 cells. so i am needing to get my formula to...

Whats a simple code for copying columns (A2, B2, C2) from sheet 1 into Cells on sheet 2 (A7, B7, C7) needing this for a macro and adding a command button that just copies it.

I am needing a macro formula for if a cell = "DELETE ME" then it will delete that row.