import excel to excel

I have a unique problem in importing data from excel table to another excel table File 1: has few column table.. all columns have text and time format data.. when i am importing this table in another file with the help of "Get external Data". it is importing data only as "text" (which is...

Hi Excel gurus I have a workbook (called consolidated) that duplicates certain data from individual workbooks Ideally, what I would like is to have a cell in the consolidated workbook where you enter the name/location of the individual file and the other cells to look that and import relevent...

hi, I am trying to import a text file based on the value in a cell or list box. I have cobbled to gether the below code to look at a specific cell but i keep getting an error stating the file does not exist and the debugger highlights the .Refresh BackgroundQuery:=False Can anyone point out...

Hello Experts, I have been trying to get this to work for some time and feel I’m very close. - I’m a beginner to VBA so by combining several other threads I was able to get this far. What’s meant to happen, Prompt user to open a directory and then copy pre-defined cells from each tab (except...

I have a few people all entering in data into excel, since they cannot be all in one sheet they each have their own copy. I would like to be able to extract all data where column P reads "Red" from each users spreadsheet and then delete the corresponding lines from their spreadsheet (end of day...

I am attempting to import multiple excel workbook tabs to a single workbook. I was able to accomplish this when converting a text file and importing but I am now getting a Runtime Error 5 with the following code. The code in red is where it is having an issue. Any help would be greatly...