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...
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...
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 :(
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"...
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...
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...
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...
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...
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...
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 ?
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....
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...
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...
Good day Mr. Excel users!
Above code works fine.
When I add Sheets("forBacklog").Activate, it doesn't work. But if I run below code, it works just fine.
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...
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...