column & header

(Using Excel on Windows with a 365 subscription) I have 4 columns. Column A is store name (Jim's or Jane's). Column B lists the date (each date from 1/1/2020 to 12/31/2020 repeated 24 times) Column C lists the hour (so hours 1-24 for 1/1, hours 1-24 for 1/2, and so on for all dates of the year...

So I am trying to use this macro. Basically I want to sort column W ascending, then use the formula "=W2*-1" in column X, delete all values in column X that equal zero and W is blank, then copy and paste the values from column X to column I. When I do this it seems to work but it is changing...

Current.png shows a simple example of my dataset. I want to count every value in column furniture and eventually get the dataset as shown in wanted-outcome.png. However, the code needs to look at the column name and not the column number. I want to use the vba for different sheets where column...

Hi, I have been working on a VBA formula to insert columns to a table based on an integer entry in one cell. So far I have managed to get it to work but as there are multiple categories of columns to add, I need to input the column numbers in a certain order as the columns are inserted based on...

Hi, I am trying to index the column headers (B1:E1) when they match colour (I3:I8), and have a value greater than 0. I would like to match all valid results and not just the first too please. An example of the results I am after are in J3:J8. Any help greatly appreciated...

Dear friends, Good afternoon! I tried both English- and Russian-speaking Google, but couldn't find ANYTHING! So, basically I have two Excel sheets - on the 1st one, I have a table containing prices for the futures at a date (column A) for a particular futures code (row 1). Please, see the...