May 2, 2025 · I am trying to filter data from one sheet (master) to another sheet based on the column that has a list of the months. I've tried using this formula but it is returns as value? 1.

Sep 12, 2011 · The way I want this to work is as follows - Select week number in Cell L17 and year number in Cell N17 on "Weekly Report" sheet - Data is pulled from the columns A, B, O, …

Mar 27, 2013 · Is this possible using either macros or formulas to pull data from sheet 2 and 3 into sheet 1? This would make my life easy since the information changes weekly.

Oct 31, 2021 · the next formula would be to evaluate the first value in column P within the range where 2018-05-09 is the value of the date in column A so you must share your real data set in …

Dec 28, 2021 · Below is the report sheet which is in another excel file on our shared drive. This data below feeds a chart. I would like to know what the code is in excel to have the report …

Jun 4, 2013 · Created this sheet in May and after much research and deliberation was able to get the conditional formatting to work; then I realized I wanted a different sheet for each month …

Copy the sheet once Rename it to "Template" Remove the data manually once If you need a new sheet: Copy the Template sheet as Work sheet and rename it Enter your data Very easy and …

Sep 19, 2024 · So my requirement is match search text in cell E1 in column A range and extract nearest due date to today's date from column C range. What function will give desired results, …

Aug 15, 2020 · The add-ins simply pull content and dump it into Excel. Manually copying and pasting data from a list or database can also prove problematic when it comes to searches …

Jan 2, 2025 · I'm working with an Excel document stored on SharePoint that has two sheets. The first sheet is for entering project data, and the second sheet contains a list of clients. I need …