database check

Hi there, Old thread I know, I'm having a little bit of trouble getting something to work. I'm also a bit of a novice, I'll admit. I'm trying to Populate a table, this I've succeeded in. Now however I need the information in a specific cell to be read and held against a portion of my table to...

Cross-posted at: https://www.excelforum.com/excel-programming-vba-macros/1355803-update-data-to-match-worksheets-instead-of-deleting-entire-workbook.html Reason: It has been up there for a few days now but no reply apart from my own replies. Link to work books...

* how to Apply Condition Formating in Particular Cells At a time, (Condition : IF then " Available Qty " <1 to Highlight Cell is RED color). * This condition Apply but Not properly Working , Pleased help to solve this query, I try to use Multiple criteria using this condition formatting.

Hi all I'm trying to find a way to create an alternative to a longwinded INDEX/MATCH/COUNTA formula in VBA, in the hope that the VBA simplifies the process, or at least has a more straightforward way of achieving the same end. The requirement of the formula is to lookup all entries in a...

Hi everyone, this is quite a difficult one i think, so here goes. i want to know if its possible to search for an item and relative price based on a customer selection. i have a form that my sales guys use for price changes and i want to link it too our database, now when the select the...

Hello, I have a list of contacts with their company and job role fields in Sheet1. There could be multiple contacts per company – as many as 50 – and if their role is CEO or HR they will have an 'x' in the corresponding column. <tbody> Name Company CEO HR Barry AAA bank x Sarah AAA bank...