filling cells

Dear All, Please Help I receive daily 1000row of data with address merge together i have to search one by one to find particular word to the accurate address for the system to understand and the address which client gives is not accurate some merge,some with comma some without spaces. Is...

Happy Friday everyone, I have 2 columns of data (A-Trans and B-Reason) - each trans in col A should should have a reason in col B. The logic I am trying to apply is: if A3<>A2 do nothing. if A3=A2 and B3 is blank, B3=B2 I am looking for a solution for this problem. I preferably am looking...

Dear all, I've been making a large Excel file with lots of data and formulas. Its supposed to be a system for a specific department. I've made a sort of loading screen/splash screen when starting up where it says please wait while the program is loading. then at the same time the workbook...

Hello, How one can achive solution in the following situation: <tbody> ID STATUS DAY1 DAY2 Day3 Day4 DAy5 H1 PASSIVE 100 100 100 H2 ACTIVE 100 500 H1 ACTIVE 100 500 200 H3 ACTIVE 100 200 500 H4 ACTIVE 100 200 500 </tbody> After...

Hi I have a dataset from a relational database that I ma using Excel VBA to format from one worksheet to another I take the raw export data and depending on whether it's header or child record data I format it a certain way in the worksheet I've two worksheets 'Export' where the Database...

Let's say I have someone enter 4 numbers in the range A1:A4. This will look as follows: 1 2 3 4 I have these numbers automatically enter the cells in a separate row. For example, the numbers go into the range D4:G4 to look as follows: 1 2 3 4 Now here's the important part. Can I have the...