Posts by Jingles3X

Hi,

I have a large spreadsheet which has street addresses, then a few cells beneath has the city. I am trying to move the city into the cell directly next to the street address. (column C has street address, i would like to move all cities to column D). I have tried a few different methods, none of which seem to be helping. I would think there is a formula or function i could use.... but am not having luck on the google trying to figure out how to craft a formula for this. My thinking is i should be able to drag a formula all the way to the bottom, then copy and paste the values entirely to a new sheet.

Could someone help me please? Sample File attached

Hi,

I am new to vba, and generally stink at it. It takes me quite a bit of time to accomplish even the basics, but I get by. I am having trouble with the following:

I need a userform to open which will display and allow me to add all of the sheets in the workbook to a PDF file. I'd ideally like to choose a filename/save location. (except for a few, which I do not want even accidentally printed or emailed).

I have tried to adapt multiple piles of code that i have found on this and other forums, with no success. Can anyone point me in a direction? I have included the xlsm file for reference.XLProposals.xlsm

I really am the guy who tries to take all the time needed before asking for help....so any help would be greatly appreciated.