predefined

Hi sir , =IF(L8>O8,"BUY",IF(B8>O8,"BUY-F","")) in the above formula the data in cell no L8 & B8 are Real time data and in O8 Predefined data , if when L8 B8 & O8 cells are Real time data then above function is correctly working but when we want to use O8 CELL as predefined value then above...

Good day everyone. I have a challenging question on VBA. I have a table that contains approximately 3000 rows of customers (customer name in column F) that are allocated to about 20 different location codes in the US (location code is column B) Each week I need to move a predefined number of...

Hi, I need VBA Code to copy data from predefined Columns from Several Worksheets into new sheet and also refresh option to erase all previously collected data.. Since it is monthly rolling task, Refresh helps me in collecting fresh data from Spreadsheets.

Hi I'm using Excel 2016. I'm trying to find a way to look for a value and when that value is found on any row paste a predefined value into column D on that same row. Here is pic to give you an idea if I didnt explain it well. I want the script to find any row with "hey you found me" and on...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Good day everyone, I would like to insert a predefined set of values (cells, rows) into an existing table , with the location of the inserted values depending on the values of...

I am looking for a macro (VBA) in Excel 2016 that when applied will search for the predefined keywords in Workbook "Keywords" Column A against Workbook "Voice" Column K to find the predefined keywords in Workbook "Keywords" Column A and those that match will be bold and red color. Sorry guys I...

Hi; I have a spreadsheet with data that looks like this; CSR 01 CSR 02 CSR 03 What I would like is to create a Search macro that asks the user to input what CSR number they are looking for (01, 02, etc). However, the spreadsheet has LOTS of numbers, so the search function MUST search for...