help

Hello The below code moves rows of data to an archive sheet when they become 6 months old (as of the current date). Could someone help me change it so it moves the data as values, rather than formulas? Private Sub Workbook_Open() Application.ScreenUpdating = False 'Set...

I have data set below where the first date is cell G33 and its a range from G33:X33. The first cashflow is cell G40 and the range is from G40:X40. Not shown below is a date of reference in Cell F42 that I need to change in order to hopefully make the formula dynamic but ultimately the date in...

Hi All, I would like a to get a VBA code that, once I press it, looks at cell D5 and then copy pastes the formula from BW34:BW36 to BX34:BX3, as well as from BX41:BX50, because cell BX6 is >= 2. The next month, when cell D6 is updated to the number 3, it should update column BY as well. Please...

Hi, Can anyone help me to treat a super small number such as -2.22044604925031E-16 as 0 instead of some number in Excel? I am wondering will ROUND function work or not? and what about TRUNC? Thanks,

Hello, I am pretty new to excel and I am trying to create a macro or by using equations to detect when a row is highlighted, the content in that row gets copied and pasted in another sheet in a specific row. How do I go about doing it? This is an example of the data in sheet2 (where the content...

Hi there I am looking for help on writing some VBA code for the following. I have an entire data tab (titled "paste 1804") I need copied into 2 different tabs with same format, content, etc..: I have Macro push button labeled "Run data Macro", on a tab labeled "Marcos" Source tab to copy...

I want to calculate the total sum of column b but also include count cells that are (yes,y) if column d has them and column b doesn't so I can get a clear picture of all the (yes,y) accross both columns.

i tried my hand at access, i have "0" experience with it, but tried nonetheless.... i have a database set up but it doesn't do what i thought it would. is there a way i can upload it somewhere and request help fixing it?

I am trying to get the extract date to be put under the "Last Use of Body Scanner" in the last image. But before that, I need to match criteria, such as name match, most recent deployment with that equipment in use, and if that personnel is certified in that equipment before the date is...

Hi all, I am calculating depreciations like this: However, my formula ONLY calculates depreciation for january if the date in column B = 01-01-2024. Is there any way to change it, so it calculates this as long as the date in column B is in the same month as in the date mentioned in column F...

hey guys - this is a tough one and I am in DESPERATE need of your Excel Guru Greatness!!! I have two spreadsheets - one has leads - one has our ICP criteria on it. The ICP has like 10 questions with say 4 possible answers per question. Each answer has a "score value" so the answers are...

Hi everyone, I appreciate everyone who takes a moment to read over the problem I'm trying to solve. The image below is a list of 10 records that equal a total of 4 sets of "Washes". Problem: Humans have to manually identify washes and remove from "Master" Sheet. We currently have to highlight...

I need to determine the range of values from Column A in my dataset where the corresponding values values in Column B are not equal to 0. Finding the the first value (in this example, 7) is easy enough, but the last value is giving me some issues. Anyone have any advice on how to solve this...

Hi all, I have this formula: Formula: =IF(J4=""; IF(I4>P4; "G4 grant bigger than Total grant (IA) by " & TEXT(ROUND(I4-P4; 2); "0.00") & " DKK"; ""); IF(J4>P4; "G5 grant bigger than Total grant (IA) by " & TEXT(ROUND(J4-P4; 2); "0.00") & " DKK"; "")) I want to expand it, so that it looks my...

My name is IMaadh, I’ve created an Excel sheet that functions as a searchable database. Currently, I can search for any single entry within the table, but I want to enhance it to search for details in two cells simultaneously. Example: Table headings: Staff Number, Username, Location...

I made a short macro with the recorder (and a little editing) to just cut and paste cells from a the worksheet. The basic setup is that I copied the data from a website and it is has multiple rows of data for each entry that can really be on a single line. The pasted data looks like this. In...

not sure if this has been asked before but running into a slight issue- I have a data set this data set does connect to a live report. i need to be able to sort on different things such as date of inquirty or ttracking number or date sent or other things- when i sort by tracking number or...

Hi All - New here so please bare with me. I would like to count the number of times a cell containing "PB" would appear for a set individual between two dates. For example in Image attached: 1. Count cells containing "PB" in the Row labelled "J D" between the dates 2/1/24 (DD/MM/YY) and...

Hello, so I'm using Microsoft Excel on Office 365 and I'm using the VLOOKUP function and having some issues. Here is the current state of my formula I'm trying to troubleshoot: =VLOOKUP(C3&"*",A:B,2,FALSE) Column A is filled with identification keys composed of letters and numbers while column...

I’m trying to count employees per hour but the problem I have is that we have people clocking in and staying past 12AM. Current Formula: =sum(((A2>=$B$2:$B$32)*(A2<=$C$2:$C$32))) A2 is the time of day so 12am,A3 is 1am so on and so forth B column is the start times of the employee and C...