simple

1. Change order when pulling cells horizontally or vertically

Hey guys, I currently have a large list of data, but to simplify, here's a simple example: I currently wrote cell C5 as = J5 I then pulled it through the green box as you see in the photo to the right and got A, B, C, D and E and pulled it down and got 1, 2, 3, 4, 5 However, I want it to...
2. Return a row (containing dates), above a row of values

Hello, please please can someone help me: I have a simple forecasting sheet, where each month a payment is made, until the value reaches £0. The example below, shows two lots of £500 per month - however if the payments were to increase or decrease this would change the month were £0 is...
3. =unique formula giving duplicates

Hey all!! I have a unique problem... pardon the pun haha. I have a really simple equation =IFERROR(UNIQUE('Lims Report'!D7:D5000,FALSE,FALSE),"") This formula has always worked for a simple list with no duplicates, and now I have a list using this formula that has given me a duplicate :( Has...
4. Mega Quick VBA Amendement

Afternoon all, Really quick one. I have some code (below) that generally works fine (to filter sheets), however, I don't want it to run on a new sheet called 'Summary' and I am getting a debug error. Can someone add a line to basically say 'ignore Summary sheet' and run only on "Sheet 1"...
5. Simple VBA Amendment

Hello all, A really simple one for you folk I'm sure. I've got some existing code which I need to adapt ever so slightly. 1) The code currently runs on all sheets except 'Summary', but I need it to run on all sheets except 'Summary' and 'FAQs' 2) The other tabs have an autofilter on row 4...
6. New to Excel need very simple help, thanks

I'm guessing this is very simple but cant seem to figure it out, I need to total the tonnage of each different type of product and put it in the table to the right. Can only seem to get it to tally the products , how do i get the sum of each product's individual tonnages? So i get a total...
7. Lock filters

Hi Guys. Is there a possibility in excel to lock the filters? Meaning that I do set up some filters for certain columns and I want prevent other file users to modify it ? Note - I do not want to lock cells to be edited, just filters. Or maybe is there a simple clever macro that would show a...
8. Calendar day coloring

Good Morning, I had a few ideas but most of them involved recreating the calendar and I haven't done that yet...anyway A user came to me asking about formatting a sheet he's got. The workbook is a simple "Planner" for work tours: He inputs a day, then inputs the number of days he's going to...
9. Simple VBA if

Brainfarting because obviously this isn't right. Ears are open. THanks If Worksheets("Developer").Range("I46").Value = "'Network" Then dpathname = cpathname Else: dpathname = bpathname End If
10. Resetting table based on day

First off, I'm really not experienced at all, just downloaded a free template from a website and just edited it and added a few simple formulas to suit my needs. So, I've got a timesheet that supposedly tracks the start time, end time, project name and all those things, mind you, not a weekly...
11. Drop Down List Pulling From Range From Different Workbook

Is there a simple way to have dropdown look to a range in a separate workbook?
12. Template to be save in simple worksheet.

Ok I have make template in excel. i want that when somebody use the template and save it. it should be save in simple excel sheet and only sheet 1 will be save without the formulas. or is it possible to save it in jpg only ?
13. Rounding while still seeing ".0"

Good Morning, I'm trying to use a simple rounding formula but I don't want to lose the ".0" when a number, say 14.96, is rounded up to 15. I cannot format the cell itself. Ideas on how to do this. It's probably super simple but I've been brain farting all afternoon/evening....
14. multiple fields on multiple sheets

Not even sure if this is possible. I have a workbook with 31 sheet and want to st up an extra sheet that pulls all the data from A22 to h42 into a list to look like 1st A22 B22 C22 E22 F22 G22 H22 1st A23 B23 C23 E23 F23 G23 H23 and then so on that I can then drag to change the "1st" to...
15. VBA Macro to Fill Down a column(s) with the same data

First of all, thank you for taking the time to read this. To keep it simple, is there a simple code line(s) that allow me to fill down automatically one column, with the value from a specific cell (I3 here), until the end of data (variable number of rows)? I have 600 files and the number of...
16. Simple Algebra calculation for variable

Looking for a way to run this in excel. x*1.05*1.1+10 = 500 Any suggestion for this?
17. If blank cel then dont calc Networdays - Formula Not working

Hi, Any ideas why this simple formula wont work: =IF(COUNTBLANK(I10:J10),"",NETWORKDAYS(I10:J10)) ? Many thanks
18. Error, must be simple trick

Hello, Good day Mr. Excel users! Sheets("OB Raw").Activate Above code works fine. Sheets("OB Raw").Activate Sheets("forBacklog").Activate When I add Sheets("forBacklog").Activate, it doesn't work. But if I run below code, it works just fine. Sheets("OB Raw").Activate...
19. XML Import Confussion

Hey all, First time poster here, but i've lurked on the site for a while. I'm looking to import an XML in to Excel but i'm having issues with it. I've used the Import wizard and feel like i'm most of the way, but i'm missing something probably simple. The XML is a few hundred records and has...
20. Simple Loop for Formatting Headers

Hi, Beyond new to VBA and macros. I'm trying to put together some simple code to loop through all sheets, excluding sheet 1, to format a varied range of cells in each sheet (if the cell has text, format it). I've been reading through all the forums and it seems like it should be simple. But...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back