doc

Hi, I have a long texts in a specific column "B", For each row, I need to split the text in multiple line (inside the same row: ALT + ENTER) after a fixed number of characters. it's like when I wrap text I need to use VBA si I found the code below in the web but it's not working Help me...

So like the title suggests, i need to be able to pull values into cells below based on the first cells data. So for example: I have a doc and in C3 i have Hewlett Packard, i would like to be able to search a different excel doc sheet that has a large list of names with 6 rows of data below the...

So like the title suggests, i need to be able to pull info into cells below based on the first cells data. So for example. I have a doc and in A1 i have Hewlett Packard, i would like to be able to search a different excel doc sheet that has a large list of names in the A column with 6 rows of...

Hello, I have found some code online which I have managed to tailor to my needs but I just need it tweaked very slightly. The problem I have is the VBA only works properly is there isn't another Word Doc open. If there is another Doc open, it will paste the excel contents into the already...

Hi i have recently created a few macros that enable me to fill in a userform and from that I can apply the input the particular bookmarks in a word doc. The macros i have created work very well so far. Macro 1 MKDir checks for and if necessary creates a directory based on a userform entry...

Hello, I have found some code online which I have managed to tailor to my needs but I just need it tweaked very slightly. The problem I have is the VBA only works properly is there isn't another Word Doc open. If there is another Doc open, it will paste the excel contents into the already...

<colgroup><col><col><col span="4"></colgroup><tbody> A B C Error Code Doc 1 Doc 2 C010 C011 e C012 The question I have is if columns B through K = "e" (meaning...

<colgroup><col></colgroup><tbody> There is folder "Doc" at C:\ that has 5 files say: File 1 File 2 File 3 Other 1 Other 2 where File 1,2 and Other 2 is pdf and remaining is msg. The formula below can hyperlink to folder "Doc": =HYPERLINK("C:\Doc","File") How to modify...

Good evening guys, As the title says I pretend to transpose data from one file to another, but just specific bits so: So I have this first excel in which I have several info that I want to transpose, namely: The thing is that I only want specific rows to be transposed, let suppose for this...

I do not think this should be difficult but I can not figure it out... I have my excel sheet completed. I want to do two separate things - ( 1 ) merge data from my spreadsheet to a word doc utilizing labels. ( 2 ) merge data from my spreadsheet to a word document utilizing a word two column...

I'm new to vba. I have a word doc with Excel merge field controls which I have Im using pull/merge selected data from Excel manually . I would like to have a button on excel sheet which on click populates or mail merge the word doc with data from Excel sheet based on the selected merge fields...

How can i average each lower level sub group and put its value in its upper level. ex Average all the numbers in E that are a 4 and place the result above in the 3 spot. Average all the numbers in E that are a 5 and place the result above in the 3 spot. Average all the numbers in E that are a 7...

Hi Guys, I need help to speed up our reporting task and I hope if this can be solve with formula or through VBA solution, if possible. Below are the conditions for the project and I'm really struggling on how I can make this work and integrate all of these in one solution. Please see the file...

I have a pivot table with data: <tbody> Doc 1 doc 2 doc 3 doc 4 combine docs 1 1 Doc 1,Doc 3 (=combineDocs(A2:A4)) 1 1 Doc 2,Doc 3 (=combineDocs(B2:B4)) </tbody> I am trying to write a function (combine docs) that combines all documents in 1 string I found this code online that I...

Evening. I am currently using a word document as a invoice sheet which I then print for the customer and also save a copy. I now wish to use excel for this task. Would you advise me to start again in excel or transfer this word doc to the worksheet somehow. My reason for this is that I'm...

Ey, ok so i'm new so i don't know how to use the coding and i need help with hyperlinking. i've copied the link address to a folder called "plans" and that is great but i want the hyperlink to open in the actual folder not the folder location. (imagine a hyperlink in excel that says 'click here...

I everybody. I'm having an odd problem. I have a large spreadsheet with lost of tabs, one for each employee. I'm using Windows 7 and Excel 2010. We need to get totals of what they have done for the week, organized by teams. But the teams change on a fairly regular basis. My plan was that...

I have just received a request from someone that wants data that we store in Excel to be delivered to them in a DOC file. Is there an easy way to do this conversion. We are using Office 2003. Thanks