keeping

I'm trying to figure out how to add 1 + 3 and then keep adding three to the sum? I am curious how to make that work, I've tried all kinds of formulas and now I just want to know to know. 1+3 = 4 then 4+3 = 7 I want to keep it running..

How does one merge several work books each has 1-3 sheets into 1 large workbook while keeping the formating and VBA in tact?

Hello Excellers , Could someone shed some light on this little issue I have: I have data b3 : h6 342 251 0 0 0 77 194 198 254 0 0 0 0 187 278 0 0 0 0 77 189 249 216 0 0 0 78 190 I would like to replace any cell value less than 100 with zero , at the same time keeping the cells that are...

I have a list of suppliers codes, most of them are in text format like ABC, DEF, XYZ however I have a few that are just numbers, 12456 6789 00056 This last one is causing me problems as the leading zeros are lost I am moving the data, trying to avoid a copy paste...

Hi all, I´ve been reading many forumns but I do not find any solution for my problem and I hope you could help me. I want to enable filtering in every part of a protected sheet. The alternatives that I have found in the forumns are not valid for me and I would like to know if there is a...

I have and excel file with about 200 rows. Consecutive columns have cells with last name, first name but in between those pairs of couple there are single names. I want to sort the file in alphabetical order keeping all the couples together and listing the single names at the end and of course...

Hi All, I am trying to copy a range of cells but keeping the same formatting. So far I have this Private Sub CommandButton1_Click() Sheets("Output").Visible = True Sheets("Output").Range("B6:E12").Copy Sheets("Output").Visible = False Application.ScreenUpdating = False End Sub Thanks Jon

Hi can any one help please. Is there a way of stopping a user to insert or delete rows and columns by not protecting the sheets and keeping All other icons and functions still available on all ribbons thank you

Hi, Is it possible to combine columns into one comma delimited column while keeping the formats from the cells in the columns that are to be combined then delete the columns used to combine with Example: From This: <tbody> This is not a Test This is a Test Number 100.123 90 is here...

I have a list of names in Column B which has the possibility of changing order if the list gets a new name based on meeting a criteria. These list of names are used to determine who has achieved an award. I need a way of keeping track of when an award was given to this individual. Because the...

how can I draw a four bar mechanism in excel using vba can I get the program for it...my four bar should look some what like wat I have uploaded in the pic... n vl I be able to rotate it keeping the upper link fixed...can u plz get me the program

I have three connection queries. One is called Work Orders, One is called Time Keeping, and the other is All EE. Currently I am merging Work Orders, and Time Keeping on Work Order # and creating a new query, then merging All EE with that new query on Employee ID. IS there a way to Merge all...