pastestart

Hi all, New to the forum to post but have used teh information many times, I have teh following to help populate a consolidated workbook which pulls in data from selected workbooks: Sub PopulateData() Dim wb1 As Workbook Dim wb2 As Workbook Dim wb3 As Workbook Dim wb4 As Workbook Dim wb5 As...

Hello! I am trying to write a program that lets me select a file, after selection it would then open the file and copy the contents in the first sheet. From here I want the code to paste (transposed) the data on to the second sheet of that selected file. Right now, this code is pasting the...

Hello guys, i am importing data from a XML file. The contents are consists of Alpha, numeric and symbols. After importing, the cell formats are showing as General. Some of my values are like Date and Time format. After pasting, Date like values changed to 8 digit number and some Time like values...

Hello Folks, Please go through the code i mentioned. The code is intended to copy all the sheets from source workbook and paste to another workbook's single sheet. My requirement is before pasting all the sheets it should look for E1 cell in all the sheets, IF the E1 cell is blank it should...

Hello, I was wondering how can I get the set PrintArea of a sheet and use that address to copy over to another sheet. Lets call the PrintArea sheet .. Sheet1 and the destination Sheet2 Sheet1 will be a sheet that has been imported from a file. The printareas are all going to be different so I...