Search results

Hi, This code is not copying the data

The above code is copying only first row of the column

Middle means the table which I want to extract data is not at the start of excel sheet. It starts from A15

No,i don't have any constrain. But my excel table is middle of excel sheet. That is the reason I am unable to import into access

Hi, can you please send the code to copy at a time and pate

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...

Hi, Do you understand my Issue?

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, Can you understand my Issue

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...

The values are keepon changing.

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 got it. There is small spellingmistake. Thanks alot

Did you try my code? Are you getting the same message?

again it is showing the same message

in which line I have to write Application.DisplayAlters=False

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

I'm waiting for your reply. Can you please help me on this. It's urgent

In Query what I have to write to import cells from A16

My excel sheet doesn't have table from A1. I want to import to Access from A16 of excel sheet. Can you pleasse see the excel sheet

Hi Nebu, I have to import to access from A15 of Excel sheet

Hi Nebu, Thanks for the Reply. Can you help me how to link all files and I have to import Part of excel sheet which are in multiple folders