populated

Can the logic below be made into a formula? Formula in cell U2 If S2 is blank and T2 is blank then U2 is blank If S2 is populated and T2 is blank the map S2 to U2 If S2 is populated and T2 is populated, then map S2 to U2 If S2 is blank and T2 is populated, then map T2 to U2

Hello, I want to create code where IF cells in Column A are populated & Column I are not populated insert today's date into Column I. I do not want a set range (i.e. A1:A100) as my spreadsheet will continue to increase over time. Thank you in advance! Jay

Hello, I'm looking for a Macro to add Thick Outside Border to set width of columns, but will only extend down to the rows that are populated with info. In terms of my spreadsheet, The top of the Thick Outside Border will cover A5 to D5 and extend down for the cells that are populated. My gut...

I am working on a form where if B14 is populated with a Person's Name C22 populates their contact info... (which is easily done) However, I am looking to have if B14 is blank (no name populated) but B20 has a name the same C22 populates the same contact info... Is there a formula or work around...

I have been unsuccessful locating code that will move a row of data to the bottom of a list once a cell is populated. I don't think this is difficult to do but I am struggling. -C

Hi I am trying to download greyhound results from a website. I can get it to work if i enter a venue name however there are different venue names so my question is how do i make it load all the different venue names and paste them into Column a after the previous venue resulkts have populated a...

Hi all, Attached is the workbook I'm working on. On Sheet1, I would like cell "A2" to designate what gets cell "A1" gets populated with. I would like these variables to be either column A or column B from Sheet2. Thanks! https://drive.google.com/open?id=1UmUrM62uza7jKe0tffbcaEgbLo_KBLiC

Can anyone help please? =COUNTIF(Calculations!$L$3:$L$100000,WACM!$G9,Calculations!$I$3:$I$100000) If I have this range and instead of putting 100000 as the last row, how would I put the last row populated? If I had last row populated in another cell, could I link to this formula? Many thanks.

I need cell X to have one of three possible outcomes, 1,2, or 3, all depending on whether cell Y or Z are populated with any value. Cell X=1 if cell Y and Z are blank. Cell X=2 if cell Y is populated and Z is blank Cell X=3 if Cell Y and Cell Z are populated. Any help is greatly appreciated.

I'm trying to use an Array formula to return all values from a field for a given customer's name and then use something (I thought probably either MAX or MIN) to sort through them to get the correct one. The formula is currently {=MAX(IF(A3='Sheet 2'!AH:AH,'Sheet 2'!G:G,""))} where A is my...

I have a spreadsheet where I pull data from incoming email notices from our jobs running. In one cell I have a formula that insert today's date when another cells in the row is populated. This works for the day that the new row is populated. However the next day when the Excel Workbook is...

Hi, I have a spreadsheet where Colin e has a date and column d has a figure. I then have a table on a separate sheet which has a date range, I.e 2/10/2017 - 8/10/2017 - and then a total cell. I need the total cell to be populated with the sum of columnd d where these figures fall within the...

Is there a way of a delaying a cell from performing the formula within that cell until a condition has been met? For example If F6 has the formula =SUM(C6-B6)+(E6-D6) But i do not want Excel to perform the formula in cell F6 until cells B6, C6, D6 and D6 have been populated.

I have two options buttons in my sheet1 in B2. I have named the first option button (Radio Button) as 'Yes' and second option button as 'No'. What I want to see happen is when a user selects 'Yes', Cell C2 should be populated with a value and if user selects 'No', Cell C2 should be populated...

Good morning. In my work the column D is populated by a word, for example "Europe", a lot of times. I need a vba code in order to find - and select - the last cell of that column populated by "Europe". My attempt is just a manual operation recorded by the macro recorder, now I need a help for...

<tbody> A B C D E F G H I J K L M N O P January February March April May June July August September October November December Month of last Visit Past Due? Extention Approved Tom May-17 May-16 Mike Nov-17 Oct-16 Harry...

Looking for away to copy a range of cells from 28 different sheets and have them pasted into another range of cells or another worksheet without any blank rows. This could be a macro but it would be best if it just self populated itself. As always thanks for all you help.

Hello, I know how to do a static timestamp by using control + shift + colon, however I am trying to make a spreadsheet do this automatically when a cell is populated. For example, when someone enters a value in cell A1, I want B1 to stamp the static current time when A1 was populated. This...

Is there a way with VBA that I can identify if a row will split over 2 pages once populated?

Hello everybody. I've a problem about one of my Excel works that I'm trying to solve unsuccessfully. There are two columns (F and G) populated by phone numbers. Unfortunately, these phone numbers are "alterated" by alphabetic characters, spaces (" ") or special characters ("/", "_", ecc)...