Anything to the left of the gray bar, when printed will be on a PDF for my client to see.Īll of the bullet points are different line items for the proposal - Example: (34) Xyz The purpose of this workboook is to be a template for proposals for my company, this page in particular is the proposal page. I am taking any and all advice, I have spent too much time on this, and I can not get it working.
There was a few different ones I was trying out, none of them worked, I dont know how to fix this, but Ideally, I would want the file name to be printed out the same as "C15" in module one. The way I am labeling them Auto delete might be the issue? Example: "=IF(T16>0,T17,"Auto Delete")" This does nothing, I am not sure why? I was hoping that it would be able to delete rows that I label Auto Delete. If Cells(i, 2).Value = "Auto Delete" Then This one works fine as it is, No issues there.įor i = To 1 Step -1 C15 is "=N8&" - "&N10" Because it fills the job number and the job name based off what the user will type into it. This module SHOULD hopfully save the entire workbook as a copy, using the name in C15, but it is currently not doing anything for me. Print the worksheet as a PDF and save it in a different folder - the folder will always be different, so maybe it makes more sence to set it as the current folder as the workbook?įirst I made a button, that calls a few different moduels - No issues there I can keep it this way, or if we could set it up in one module that would also be fine.Īll of these modules I have found by googling, and then tweaking it slightly, because of this, I do not know exactly what it wrong with it.ĪctiveWorkbook.SaveAs Filename:=wbPath & newWBname Delete entire rows, that have a specific word in themĤ. Delete all check boxes on the current worksheetģ.
Save a copy of the entire workbook, in the same folder as the currentwork book, but with a slightly different name.Ģ. I would like to create a button on my sheet that when clicked, it will do these following tasks (In order):ġ. However in this case, I can not seem to get it working, and I am not sure why. I am not a VBA coder at all, I have built the last couple of sheets using frankenstine code from googling it, and tweaking it ever so slightly to fit my goals.
Support for simple Vim-like editor and shortcuts.Ignore clipboard copied from some windows or containing some text.Advanced command-line interface and scripting.Paste items with shortcut or from tray or main window.System-wide shortcuts with customizable commands.Sort, create, edit, remove, copy/paste, drag'n'drop items in tabs.Quickly browse and filter items in clipboard history.Store text, HTML, images or any other custom formats.Support for Linux, Windows and OS X 10.9+.Saved clipboard can be later copied and pasted directly into any application. CopyQ monitors system clipboard and saves its content in customized tabs.
0 kommentar(er)
