Search results

Hello, I tried your code and is still not working. Perhaps I keep making the same mistake all the time. Could you please change and upload the file I attached to try to understand where my mistake is? One more question: first line As Double means it will apply only at 2 sheets? Thank you for...

Hi SirJB, I tried to implement the changes you told me about. I still can't make this one working. If your schedule allows you, please take a look at the attached file and let me know what I did wrong. Thank you.

Hi Narayan, I checked this one and is working. In hidden mode is not inserting any more duplicates and and is working normal when deleting spreadsheets. It's a real nice features. Thank you

Hi SirJB, Fore some reasons I can't make this one working. This is what I did: 1. I inserted a module and renamed it as AlmostSumAll 2.I changed the"Name" in line 11 with my workbook's name(in both places) Thank You PS:I don't now what to do with C1: =AlmostSumAll()

Hello , After Anupam brought those 2 issues I actually discovered that if I delete one of the duplicates it will delete or rename another page from the work book. I will keep Main visible and I will work this way(not a problem). It will be nice to have this problem solved just for future...

Hi, SirJB It is only 1 workbook and Main is the spreadsheet where I would like to have this sum. I want to exclude Main because I also have some data which I would like not to be counted. As far as VBA, my guess is it will take less computer resources. Thank you.

Hello all, I would like to sum all A1 cells from a workbook in C1 in "Main"spreadsheet of the same workbook. Also data from "Main" should not be counted. The number of sheets it is unknown Thank you for your help.

Thank you so much! It is working perfect.

Anupam, thank you for your reply. What I would like to do is to keep the Main hidden and when I click on Insert worksheet to have a sheet identical to Main. Perhaps a VBA will solve this but I do not have enough knowledge to make it. Thanks again.

Hello , It is possible to insert a new spreadsheet with properties (tables, formulas,column width, etc) identical to a reference spreadsheet(Main) inside the same workbook without using copy-paste? Thank you for your help

It will be as column length. Thanks

This is working really nice , but I saw that this formula takes a lot of computer resources for very long columns. Is there another way to solve this(perhaps a VBA code)? Thank you again for your reply.

Thank you Faseeh, This is working nice.

hello, This is an example file for what I would like to achieve. Thanks.

Thanks. I will upload an example file.

Hello all, This is for a punch clock in excel. Using cmdIN I am able to insert a personal code ( col A ) and next to him computer’s time (col B) Using cmdOUT I am able to insert the same things in col F(personal code) and G(computer’s time) It is possible to bring time out next to time in (in...

Thank you all for your replies. I got really good tips from you. I think we can close this on as [Solved]

Debraj, thank you for your post. I tried your code and is not changing or adding anything to the spread sheet. The code that I posted above is attached to a cmdbutton. Where should I put yours?

Hello all, Since this post was started a couple of day ago in the old forum I decided to bring it back in this one. This code(thanks to coolkiran) is inserting computer's time in all cells belonging to column C for the same IDnumber as in Col A. I would like to change this code to insert...

It is working really nice. Thank you so much.

Thank you for your answers. It is doing what I asked for but I run in other thing. I was hoping that if I format cells C1 and D1 as numbers I will be able to turn 07 in 7 and 03 in 3(using 4-0703 as test number). Is there a way to make this numbers ?

It is possible to split a text from a cell in multiple cells? For example I would like to split 4-1405 from A1 as 4 in B1, first 2 digits in C1 and last 2 digits in D1. Thank you.

Hello, This is the code I use to insert data: Private Sub cmdIn_Click() date_test = Now() Dim iRow As Long Dim ws As Worksheet Set ws = Worksheets("Sheet1") 'find first empty row in database iRow = ws.Cells.Find(What:="*", SearchOrder:=xlRows, _...

Hello, I created a form to introduce some data into a worksheet. When I applied a formula in one cell(col D) I saw that the data skipped that row. My guess is, the problem is the 3rd line in the code.I would like the code to look only for the firs 2 cell empty in that row instead of the...

Thank you SirJB Everything is working as I want. One more question: how to call a Frame, a combo box and and check box.