pretty

I have data in this format <tbody> A d B e C f A g B h C i </tbody> and I want <tbody> </tbody> <tbody> A B C d e f g h i </tbody> for about a thousand rows; and preferably not a macro. Pretty sure this must be a common problem, but couldn't find it here. I thought it was...

HI, I have a list of dates,with times in column A and a value in Column B, which corresponds to the time in column A. I am looking for a formula, that will only give me the date and times with the minutes 30 and 00? Im sure it's pretty easy, its just been a long day and appreciate any help...

Hi, I'm trying to filter out two seperate columns on spreadsheet with values of zeros. Basically, I want to filter the columns that BOTH contain values of zero(not just one). I was think of using a nested if statement(I am unsure if that is the most effective method). I'm pretty green at...

I was wondering if there are any additional security tips beyond password protection for VBA modules since VBA passwords are pretty easy to crack? What others things have folks tried?

Hello all, I'm sure this is an extremely easy fix for a seasoned excel pro but i just can't find the answer. Here is the code i have in another function and it works just fine for copying data into cells. 'copy Fixture Locations, Quantity, and Ceiling Height...

I'm trying to create a workbook broken down by quarters, each quarter with its own input page. I want a user to be able to enter a 1 to indicate yes to a certain field. Once it is filled out they can then hit a submit button that information would be added to cells in different worksheets within...