Re: Auto Populate troubles
Ok I had it down pat and than when I saved and closed the document it no longer works properly. I figured out the formula for the above post. But again Im still having the issue of it not grabbing that information. It was working perfect I added a few columns and fixed a few of the other formulas but didnt alter them and they broke. Any help would again be more than appreciated.
Re: Auto Populate troubles
Perfect that does exactly what I need it to. Thank you very much.
Now what Im trying to accomplish is an if statement that will look at c15 and if a cc was used than it calculates a different total. =A23*16+IF(C15=,A23*0.5,0) is what I have came up with im just not sure how to tell excel that no mater what the value as long as something is in that box it multiplies it by .50 which is the charge for using a CC. Let me know if that doesnt make sense.
Re: Auto Populate troubles
No thought?
Re: Auto Populate troubles
im still having a bit of difficulty getting this pinned down. Any help would be more than appreciated.
Good afternoon,
Im having an issue trying to get forulas and just the formulas to paste properly EX:=SUM('# Install Pending'!R5, '# Install Complete'!R5)-32, turning into =SUM('[Copy of DNR SALES LOG.xlsx]# Install Pending'!R5, '[Copy of DNR SALES LOG.xlsx]# Install Complete'!R5)-32. Its keeping the original workbooks title altering where the info is being grabbed from. I am currently using a copy of the reports to make changes to them but when I bring the changes over the whole formula gets altered to keep the same refernece point rather than alter to grab the information from the current workbook it is in.
And I would rather not go through over 300 cells taking out those [Copy of DNR SAles Log.xlsx] on every one
Any Idea i have tried turning off auto update formulas, as well as special copy and paste but it isnt allowing me to copy just that formula as it sits in the current cell.
Re: Auto Populate troubles
Copying to the individual cells doesnt work I have tried a few different ways of accomplishing it. It has to be a vlookup and pushing option but im not the best at the vlookup options and codes. Still stumped....
Re: Auto Populate troubles
I have since made a few attempts to narrow the field down by individually telling VB where to send that specific information but that didnt fix the runtime error.
Good morning Fellow Excelers,
Having a few issues trying to nail a VB porject I have going on here. I have attached the files, in a workbook setup. First off what Im trying to get accomplished if its possible, Is a VB tool that will allow the connected Billing sheet be auto populated with information from the CO2 Log when the information is input into one cell. What IM trying to do is have the Information in column C of the CO2 report to the billing sheet, once the number in column c is input into the billing sheet in I4-J4, all associated info on the rest of that table gets input into corresponding spots on the billing sheet. So than as the file shows all of that information they would need populates into the corresponding spots on that billing sheet. It has where the info should transfer too already shown on the attached. I have another thread/stream written for another form I use that I altered to try and accomplish the same task but unfortunately I dont think it will do what I need as the info that was transfering to the same layout is just to another sheet. So like table for like table, this information needs to get split up and input into the associated places. Any assitance would be more than appreciated. Thank you for your time.
Anthony
Re: Transfering issue
Its not letting me attach the whole book its over 250 kb which i guess is too big for this site???
Re: Figuring out abbreviation
Still having trouble with the abbreviations I was thinking a lookup but its not working properly i keep having to run the macro rather than it just doing it. And I keep having to hit it to get to the next words to abbreviate. Meaning I hit run it does the first abbreviation in the string, I do it again it does the next rather than looping through them.
Re: Transfering issue
Ok the only problem I am having now is implementing it in the complete book version of the forms. And I cant get it to transfer the macro doesnt come back with any errors its just the info isnt showing up on the EP3 page as designed. The total workbook has 15 sheets to it, The device tested page is the 3rd of 15 and the ep3 sheet is the 13th page of 15. Im not sure that should matter as I see it referencing a specific page name not number of the page, but I could be wrong.
Re: Transfering issue
That looks like it does the job I had to keep it the same since that is the way the fire marshals need to see it in a set order, they are pains. But anyways I just swicthed the look up column but it works perfect I also have a macro automatically abbreviating as well so as they put in the info which they primarily use copy and paste from another program that grabs all the info off of the system itself causing less errors so when they pop all the info in it changes those full desriptions that come out of the panel abbreviate them using again the above shown legend then transfer dpending on the selection. ITS PERFECT. Exactly what I was trying to accomplish, THANK YOU VERY MUCH. That was the main part that was stumping me. Again I appreciate the help greatly Mumps.
Re: Figuring out abbreviation
Still stuped on this one its altering the entire page taking anything with the associated words and altering them all rather than just in c column. Also I have to write mutliple points on this to alter all associated abbreviations. Im trying to put in a specific order so that thsoe with certain words that dont have to do with the others trying to make a specific as possible so it does those first than onto the ones with less specific titles. as the attached file shows.
Re: Transfering issue
NO luck on this one yet still ending up with a error, its compiling data in same place rather than using new line, that hasnt been copied to yet.
Re: Transfering issue
Started to write a long if statement but had to stop realized that the ending IF statement wouldnt transfer properly, and a vlookup isnt going to accomplish the needing to go to the next line on the following sheets. Still stumped
Re: Copy rows to different sheet starting at a specific row.
i Have been parusing the forums trying to find something that would be similar to this but having the data only copy the row if a specific option is made. Eample say I have a cell c27 which would be the area of an abreviation it would have to read lets say FD if that specific abbreviation is used in that cell than the whole row a27:h27 would than copy onto another sheet. Going down each time depending on selection, the ones that need to transfer are in red and the attached sheet stating ep3 is where it would have to transfer. forum.ozgrid.com/index.php?attachment/54379/ See example attached for extra clarification but does that make sense?
Re: Figuring out abbreviation
I was thinking that at first along with the if statements that I had semi working but it started to get way to long, but was unable to get my simple version of the vlookup to work properly, so I came up with what is attached in the macros on this sheet here forum.ozgrid.com/index.php?attachment/54368/.
Re: Figuring out abbreviation
Yes to answer your first question, that is exactly what I need to accomplish.
Also is that what you needed me to do. that was new to me Sorry about that Ill go through the forum rules again just to make sure I have everything right. Thank you for the heads up cytop. 
Re: Figuring out abbreviation
Ok ive tried my script but it doesnt seem to be working. I even try and force the run but it doesnt alter the full desription into the abbreviation Ive uploaded to see if anyone sees where the error is. Any help is more than appreciated
Re: Figuring out abbreviation
I cant quiet figure out how to remove I click the # button but its not taking away the colors. But this works as well, I have the macro and the sheet i attached it too on the second page
