Re: Figuring out abbreviation
Also would vlookup method with hidden cells work, a simpler if statement to check corresponding text and input the finding found in a hidden cell. Just a thought ive been going back and forth with someone that has a bit more experience and it sounds good in thought, but is it doable is my question i guess?
Good afternoon all,
Having a bit of a problem getting code worked out to transfer whole rows of information upon selections of specific information.
I also have a descriptions in the actual file itself. The red area are the problem childs, and the yellow is wheer the abreviation goes for the specific devise. If a abravitation is input of only specific devices it than takes the whole row of info and transfers it onto the other sheet in the workbook. I think that makes sense.
Any help would be more than appreciated.
Thank you very much for any direction.
AnthonyS
Re: Figuring out abbreviation
And here is a small example of one line filled out I could do more if needed or just copy from an old report to make it easier to understand. Please let me know, and again thank you very mcuh for the hand in this 
Re: Figuring out abbreviation
The reason for the alteration into abbreviations is that me and another tech wrote a program that takes events from the panels themselves using another program than wrote code in java and other scripts and stand alone system that takes the events logs them into a database than tranfers into the right format for easy copy and paste onto this device tested since some hospitals have over 1000 devoces and all need to be tested
Re: Figuring out abbreviation
Oh meaning that its blank, yes at the time it is blank because the tech in the field gets the address from the panel itself and enters it there the physical address what may go there is something like N2L23D354 Thats, Node 2 Location 23 Device 354 or may be an easier location like Third floor west corridor smoke or something along those lines different for every system. Sorry about that.
Re: Figuring out abbreviation
What, raw data for what exactly??????
Im confused now
Re: Figuring out abbreviation
Ok sure thing, thank you for the heads up I didnt even think to attach it honestly. and if statements are a pain Ive been writing alot of them to try and go through specific options for things just making it run all the diferent variables, rather than a macro cause I can use excel well just not VBA. And what im trying to accomplish is after the abbreviation is found Im trying to write something slowly, as its coming along slowly by taking just specific sets of those abbreviations and transfering the cell and as you can see all the accompanied cells in the row onto another sheet in a workbook that that sheet is attached to. But thats a tougher one Im thinking. Any help again is greatly appreciated thank you very much for your time.
AnthonyS
Good afternoon all,
Im kinda stumped i was trying to write a script in ways to take an entire descriptions of devices and turning it into a set abbreviation for it. Like if there was a table at the top looks like this shown at bottom. I was thinking an If statement like =IFS(CODED MANUAL STATIONS,"MS",IFS(AIR SAMPLING,"HSSD"),IFS(HALON MANUAL STATION,"HMS",IFS, and so on but I didnt know if that would be the best way to do that?
[TABLE="width: 81"]
[TD="class: xl64, width: 108, bgcolor: transparent"]NON-CODED MANUAL STATIONS – MS[/TD]
[TD="class: xl65, bgcolor: transparent"]AIR SAMPLING – HSSD[/TD]
[TD="class: xl65, bgcolor: transparent"]HALON MANUAL STATION – H-MS[/TD]
[TD="class: xl65, bgcolor: transparent, align: center"]ABORT SWITCH – AS[/TD]
[/TABLE]
Re: Filtering out duplicate information accorss a Table
Thank you it worked perfect I, lol i even tried it a few times but it hadnt given me the desired effect until i threw in a table set then choose just one column. But thank you very much I appreciate it greatly I was spending alot of time trying to reorganize.
I have a lengthy excel file with multiple of the same information in the row. What I need to do is take out all the rows that have the same information. So i would need only one of say the 10 rows that all show the same information. Is there an easy way of doing that? Thank you for the halp.
Re: Printing Issues
I even added a reg edit that well was supposed to fix the issue QFE_Sitka modified and set to 1. Apparently that should have fixed the issue and this answer was found on microsofts site itself. So any other suggections would be helpful.
Good morning all,
I've been having some printing issues with some forms I have created. Most of the users who are utilizing the forms are not having issues there are a few though that when they try to print them or view them they are stretching to multiple pages rather then the one its supposed to be set as. Im trying to figure out why their view is skewed and why its not keeping the printing setups that are currecntly configured as most others do. We all use the same version and updates to excel. Just wondering how and why it would move checkboxes and move wording and messing w/ printing aspects. Any help would be greatly appreciated. Thank you very much for your time.
Anthony
Re: Checkbox transfering
This is not what my form looks like its just an example to show people what I need to accomplish cause last time I tried to post they said I needed a example and my forms are too large to post as well as having sensitive data that cannot be shared, not what my form even close to looks like this. good job super moderator in epically failing.
[INDENT][INDENT][INDENT]Hello I have an issue I could use a hand in figuring out. I have a workbook for inspections, with checkboxes for yes no and N/A. And on other sheets on that same workbook that information once selected on that specific point needs to transfer the selection onto one of the other sheets on that workbook. So only certain parts of the inspection having to do with just those specific parts of that inspection transfers. Say one reads has system reset properly the individual will select yes and that selection then moves to the specific tab or sheet having to do with that type of inspection so they dont have to go through both sheets and select all the same info multiple times. Is this possible and how can it be accomplished.
Thanks Anthony
[ATTACH=CONFIG]51698[/ATTACH]Here is an example of what Im trying to accomplish[/INDENT]
[/INDENT]
[/INDENT]
I have to take the selections from sheet a and have them autotransfer once selected onto sheet 2 and 3 where applicable.
Re: Checkboxes
Here is an example. The 1st sheet is and example of some of the things on an inspection then on sheet 2 the A. is supposed to transfer from sheet 1 too 2 with the selection that was made on the 1st sheet. And B on the first sheet needs to transfer to the 3rd sheet and again its just the checkboxe data that needs to transfer.
Re: Checkboxes
I cant upload them as they are too large. But say one of the parts say a-1 does system reset normally with three checkboxes associated with that, what ever the selection should match up to the same information on sheet 2 and say a-2 says does system refill noramlly and when they select the yes no or n/a that selection will also transfer over to say sheet 3. its certain questions are reasked on the other sheets having to be that way due to indepth procedures having to do with fire inspections. So rather then have my employees go through all the sheets and select the same answers two and three times Id like them only to have to do it once.
[INDENT][INDENT]Hello I have an issue I could use a hand in figuring out. I have a workbook for inspections, with checkboxes for yes no and N/A. And on other sheets on that same workbook that information once selected on that specific point needs to transfer the selection onto one of the other sheets on that workbook. So only certain parts of the inspection having to do with just those specific parts of that inspection transfers. Say one reads has system reset properly the individual will select yes and that selection then moves to the specific tab or sheet having to do with that type of inspection so they dont have to go through both sheets and select all the same info multiple times. Is this possible and how can it be accomplished.
Thanks Anthony
And why does it take posting something several times I see posts around mine looked at doaens if not 100's of times and answered after a minutes time yet mine don't ever get looked at or answered, Just wondering[/INDENT]
[/INDENT]
