based

This feels elementary, but I figure this is the best place to ask. My starting value is 1000 and I would like to add 500 every x columns (dynamic based on cell input). Can someone help me write the formula for this request?

Hello, I would like to be able to delete all rows in a spreadsheet based on a specified value in a selected column. I currently have a macro to delete a row based on specified cells but I'm not sure how to make it delete all rows with cells in a column EXCEPT a specified cell based on an input...

Hi Community, Been trying to figure this out all morning. I have a range of data, with column headers. I have computed values based on certain criteria in a range of cells Similar to the following: Lets call it clothing items. Mon 400 Tue 300 Wed 6 Thur 7 Fri 50 I...

I have a listbox that allows for multiple selections. However I want to select just one of theitems based on a variable value. So I will set variable “Department” to the value in cellD28 Then use that variable to select just that one item from themultiselect listbox. Prior to...

Morning all! Was working on an excel spreadsheet and could use your help please! Based on the table below, is there a function I could use to populate another cell with either "Yes" or "No" depending on the table's data? More specifically I have two separate sheets that are populated with...

Hi I have seen lots of discussion on VBA moving rows to another worksheet based on a value eg "done" which have worked for me. However what I am currently trying to do is move rows based on date, each row has a due date and once this date has passed I would like to move the row to a different...

Hi, Drop down list value is in D2, based on that value it will autofill range B2:B31. If the value selected in D2 is 24 then Autofill range B2:B31 to 24,48,72 to 720, same as when selected 30 then 30,60,90 to 900. I would like to do this in macro. Thanks

Is there a way to set a filters criteria based on a list of variables? I have a master list of names of all employees. Some employees get reassigned to new areas on a regular basis. I get schedule updates from their supervisors each week. The list of employees by each area changes. What I'd...

I have simple table below that will work out return and place into E1 if a W is placed into C1 Back Odds W/L Formula Result 15.00 2.5 W =IF(C1,"W",A1*B1 37.50 how can I change the Formula to also check if a L is placed into C1 and show the result as a minus figure...

Hi Team, Can anyone help me with a macro which will create diffrent PDF for each page in a sheet and name it based on cell value and save in folder on desktop. Example : i have one sheet with 30 pages in it all page have similar format. i need a macro which will create diffrent pdf and name it...

Hi, I need a code to delete some duplicate Name Ranges which have identical names but have different scopes. For example, my file has two "List_Tabs" Name Ranges; I want to keep the one that has a Scope = Workbook and delete the one where the Scope refers to tab name "Info". How do you delete...

I have a sheet that i have columns numbered 1-31 (Days of the month). i have another sheet that has a cell with a Today() formula. when i activate the macro i want to get the day of the month from the Today() cell and based off of that day i want to add a number underneath the corresponding day...

Hi all, I have a PDF with 20 pages and I want to split it into 20 different pages. I wonder if, appart from the first petition, could it be possible to rename those files that are going to be splitted, based on a list of names that should be in an Excel file. Any ideas? Thanks in advance for...

I've got a sheet that works out the lower and upper limits of parts based on certain criteria, I want to display the parts available between and including these numbers. The 13 available numbers are based on the strength of the part, so 35, 40, 63, 65, 80, 85, 100, 105 etc. If the cells show 63...

I am doing a project timeline chart in excel. I have 3 series in stacked bar chart.The categorization of the series is based on the first two columns of the chart. The fourth series is just displaying the data label. All the three series in the chart is the difference between the different...

Ok i have asked this question already before but i have gotten no where. I have simple standard cell that i enter a Name, Company, City/State, phone, and email. I would like for that information to be transferred to a table on a different sheet. I then want to use the name cell from the first...

Hi, I am wondering if there is anyway to calculate the Product for column "value" based on category with just using excel formula? For example, based on the table below. I want to find the product for category A = 1*2, category B = 3*2*2 and C = 3*1*2. I tried using SUMPRODUCT but instead...

Hello, I have a Fact table like this: <tbody> Product Customer Region Date Sales </tbody> In the middle of a calculation, I would like to put that table in a variable with the following filter: <tbody> Based on...

Hello, thank you for taking time to read my message. I need some help, and after searching, I dont seem to find the answer. Hopefully, I can find help here. The goal is to sum revenue based on a average sales price per item. I want to group this sales based on price point to learn the...

Hi all, newcomer but really happy to be here! Kindly excuse any noob-ishness... I'm having a problem with conditional formatting that seems to be going on for almost 2 days now. I have been setting up a project planner tool based on a template I found online that produces colored timebars based...