Search results

Thanks Narayank! Almost perfect, I need one more row added per letter. A=2 rows below unit # B=3 rows below unit # C=4 rows below unit # D=5 rows below unit #

Attached is the example. I need to add a certain number of rows under column A (bldg-unit) based on what letter is at the end of the text string.

HI, Im looking for a macro to insert cells based on values in certain cells. I have a list of unit #'s that contains an A, B, C, D or E in the text string and I'm looking for a macro to insert a certain number of rows based on what is in that cell. For example in cell A6 the value is...

I would name the pdf the same as the excel workbook. What I meant by pdf based on tab name is to pdf certain tabs together based on what they are named. Sorry for the confusion. I'll try out the code in a few. Thank you.

Hi SirJB7! I was able to extract the files and code works. I did notice it would just PDF each tab and seperate them individually. Although, I can see this code being very useful in the future it isn't exactly what I need at the moment. I need the pdf's to be combined into one PDF and I...

I can't open the 2nd link. It saying it isn't a valid Win 32 application.

Code isn't working for me...Its not giving me an error but it doesn't appear to be working at all. I feel like something is missing. Should the workbook contain the file names or the tab names I want PDF'd? Here is the code: Sub PDFMMR() ' constants Const ksDir = "C:PersonalExcelPDF"...

Thanks for the reply SirJB7. Good one on the macro name, got a chuckle out of me. A few questions on the code so I can test it out(VBA Novice over here). Consants: Const ksDir = I'm assuming file path of where the workbooks are located goes here? Const ksExt = Name of workbook with tab...

I've searched through the website and I can't quite find what I'm looking for. http://chandoo.org/forums/topic/command-button-code-and-code-to-saveconvert-the-active-sheet-to-pdf This link would work great if it wasn't for only one workbook, but I need to do this for 100 workbooks. Honestly...

Thanks SirJB7! I will take a look at those links and let you know if those help me out.

Hi, I have 100 workbooks with 10 or so tabs in each, we have to save certain worksheets as pdf's to send out. I'm looking for a macro to PDF worksheets based on tab name. I'd like to not have to do this individually in each workbook as that would still be time consuming to open each workbook...

That's what I originally did, but when I change the budget start date the IF function would return the wrong month. I'd like to keep the budget start date function as we do budgets with different starting months. SetupC19 is a start date for the budget.

I'm working on revamping a budget and part of the addition is to have an option to set a start date of the budget that automatically adjusted other tabs. But in setting up the budget this way I have ran into an issue of budgeted expenses. I want to have a drop down list of months to choose...

The dates in column 21 are linked to a setup page that lets us select a start date for the budget.

Here you go. https://www.dropbox.com/s/q1gbanqqdwuxrcr/Budget%20Template-Expense%20Tab.xlsx Basically I want to have Jan,Feb,Mar in column I instead of A,B,C. Thanks!

I'm working on revamping a budget and part of the addition is to have an option to set a start date of the budget that automatically adjusted other tabs. But in setting up the budget this way I have ran into an issue of budgeted expenses. I want to have a drop down list of months to choose...