Hi,
Thanks for your reply.
My code is copying the data correctly but I don't know the reason why it is changing the values of master sheet which are already saved.
Hi,
I have a main folder containing 25 sub folders. daily I will add one new excel sheet to each sub folder. I want to copy part of the Excel sheet data from 25 excel sheets which are in 25 sub folders and paste in a new master excel sheet.
Then I have to upload the master excel sheet in MS...
Let me clearly Explain my situation,
I have a main folder in that there are 25 sub folders. In each sub folder daily I will update one excel sheet. I want to import the part of data to Access from each excel sheet.
For example I have entered one excel sheet in each sub folder today.
So there...
a) Path of Access File(Documents)
b) Path of Excel file(Desktop)
c) I want to extract Data from cells(A15, L15) to (A36,L36) condition: if Date column exists then only it has to extract that particular row
d)Aceess table structure is same as excel sheet structure.
Please tell me if you need any...
Hi SirJB7,
I want to import part of excel sheet to Access which are in multiple folders. and In my excel sheet the first row is not table. The table starts at A15. So I want to import data from A15.
As this not possible directly I thought to Copy the desired dataa from each excel file which are...
Hi,
when I am processing Macro in second excel file it is cpoying the data into main sheet but it is changing the first sheet values(See mastersheet). If I am processing macro for the same sheet twice then the values are not changing(See sheet2). Please help me on this.
I have tried this macro to extract the data and save in a new file. But every time it is showing below message
Macro I used
Sub copy()
Dim i As Integer, erow As Integer
'LastRow = ActiveSheet.Range(“A" & Rows.Count).End(xlUp).Row
For i = 16 To 36
Range(Cells(i, 1), Cells(i, 17)).Select...
That's why I want to extract necessary fields from all the sheets which are in multiple folders and save in a new master sheet and then import to access