Search results for query: *

Thanks a lot "anotherhiggins" this is great, I didn't know this feature. The only problem is that I didn't describe properly. I have Item List starting from ROW 9 and some items have different issues involved that I put in COLUMN B. So I'll have in COLUMN A & ROW 9 "Item #1" but in COLUMN B I'll...

I have a table with Column A setup to show topic number. I have about 25 topics listed in table but when I insert row, numbers stay same. I have to go and renumber all rows after I insert row. Is there a way to do this so that when I insert row, it will automatically update row numbering and...

xlbo, is this a very large code for VBA? Would it be very hard to do it?

It is closer to what I need but still no exactly to what I was looking for. I have an issues log where I put date as a target for completion for each task. When I put a completion date in cell, I have conditional format to shade row but these rows build up and some issues have been closed and I...

Does anyone know if it is possible to have, if cell for example c8 has letter "C" then to hide that row. Or is there any other way it can be done so that if cell contains data then to hide row automatically.

Sorry Skip I didn't get back to you right away but yes the source data range is formatted as date. I give up. Thank you for trying to help me out.

I tried to format X-Axes label -date -3/18/98 but I still get 5 digit number displayed. I just can't figure it out how to change that. When I open link source the 5 digit date number changes automatically. Any more suggestions?

Does anyone know why when I have excel file open where I link my X-Axes that shows dates from another excel file that have dates shown in one column, if I have both files open, dates show no problem. When I close the file where I link from, then in my file where I have chart, X-Axes date labels...

Thank you SkipVought, that's a very handy option to know. The only thing that I want to know if I do the way you said, and save this file on network with these command buttons, if other people open this file, will they will be redirect to same folder?? Or is it just my computer will be set to...

Can someone please help me. Thanks in advance. In Excel I'm using click button to have "Open File" window come up. I would like to do, when I click button I want "Open File" window come up always defaulting to same folder and I then I will select file I need. Right now I have...

Can someone please help me with this, I have two tables that I want to create scrap collection for 2 parts. I want to make form that would have date which would be same for both parts since I'm checking for scrap same date for 2 parts. I want to have same reasons for two parts for scrap. Here is...

Thanks for your response. The only reason why I'm creating two tables is because I'm trying to collect data for scrap on my line. There are two parts involved so I would like each day to enter "date" and then enter in two text boxes number of scrap for each part. So it's going to have...

Sorry I forgot to mention that under FIELD NAME "Date" is my primary key.

I created table named "A" that contains: FIELD NAME DATA TYPE Date Date/Time Length Number Width Number Height Number I would like to create another table "B" that will have FIELD NAME linked to "A" and number will be different...

What I'm actually looking for is to have lets say in column A (A1:A10) square check boxes. I would like to double click inside check box and be able to put check mark in there or double click and take check mark off. Is that possible? I really appreciate your help. Thanks.

Mike can you please help me with this feature. I have never used visual basic but would love to learn a little bin. Can you show me how to do it. Thank you very much.

I have a sheet that I need to have check boxes for different fields. I wanted to know if I can insert check box so that if I finish something, I can double click and have checkmark to be put into that box. Thanks.

Thanks a lot for letting me know this. I never wrote macro and if it's not very hard could you please help me to do this (Walk me through). I made this worksheet for operators and would like to make it as simple as possible, I want to save them from inputting date and time when they enter...

Anybody has any suggestions?? If you do please let me know. Thanks.

Thanks a lot! Date CTRL/; Time CTRL/: (CTRL/SHIFT/;) These commands were very helpful. I still didn't get answear for my initial question. Is it possible to have formula in various cells to put date when you enter number one cell below and then save. When opened again the...