Get instant live Excel expert help to learn how to use Small function in Excel

I want to merge multiple files into 1 master file with the help of VBA. There will be around 3k small files in a folder that need to be merged. Also, want to add 1 column/field in that final file which will show the source file name from which the data is taken. so at the end of the VBA run 1 big file with all the record from different file plus 1 extra column with the file name from where data is collected

I am done trying posting it to the right queue (VBA) but I guess no one is expert enough in VBA team to handle my query that's why not picking up my query I want to merge multiple files into 1 master file with the help of VBA. There will be around 3k small files in a folder that need to be merged. Also, want to add 1 column/field in that final file which will show the source file name from which the data is taken. so at the end of the VBA run 1 big file with all the record from different file plus 1 extra column with the file name from where data is collected

Hi How do I separate the first and last name in column B and if there is no first capital letter in the name I would like to add that. If the name is in Full capital letters it should also be changed to first letter capital and the rest small. If there are 3 names in the column than the the last one should be the last name and the other ones first name

I need to combine two Excel files having all of the tabs, macros, etc.. from the Small Business template, brought over to the Master TimeSheet Calculate following the Employee Information tab. I need them combined so I have one excel file that is not linked to any other file than itself. There are Macros involved.

I need to combine two Excel files having all of the tabs, macros, etc.. from the Small Business template, brought over to the Master TimeSheet Calculate following the Employee Information tab. I need them combined so I have one excel file that is not linked to any other file than itself. There are Macros involved.

I need to combine two Excel files having all of the tabs, macros, etc.. from the Small Business template, brought over to the Master TimeSheet Calculate following the Employee Information tab. I need them combined so I have one excel file that is not linked to any other file than itself. There are Macros involved. I am willing to go beyond the 20 min mark.

I have a bar graph (the first graph with a minimum data value of 10 and a max value of 270. For this reason the bar with the small value appears very small. How do I change the y axis interval so that the value 10 can appear taller?

The below formula has a defined path '[TOC Model.xlsm]Partlist'!. This makes it choose a specific worksheet in a specific file. I need a vba code that can replace the hardcoded path with a user defines file chooser. The worksheet tab name (Partlist) remains the same Range("B2").Select Selection.FormulaArray = _ "=IFERROR(INDEX('[TOC Model.xlsm]Partlist'!R2C2:R10000C2,SMALL(IF(RC[-1]='[TOC Model.xlsm]Partlist'!R2C1:R10000C1,ROW('[TOC Model.xlsm]Partlist'!R2C1:R10000C1)-1),ROWS(R2C:RC))),"""")" Selection.AutoFill Destination:=Range("B2:B5037") Range("B2:B5037").Select

the previous expert worked on a formula that worked perfectly from his end when we tested is giving me a reference error. need small assistance

spred is excellent its in a landscape format...full screen I go to attach it or print it and as I click on file....it reproduces a small version of the copy to the write and that is what is sent or printed....I was Ok all day yesterday but do not know what I did wrong or how to correct