Hi,

I'm new to Macros and have no prior programming experience. I have 2 weekly files that always contains the same number of columns but different number of rows [ex. 1 week it will have 3K rows, another week it will have 2K rows, but always 6 columns]. I need to make the two sheets into table to do further analysis; can anyone please help?

I want to write a code that allows me to do the following in the following order:

1. Select only cells that contains data in sheet 1
2. make a table using data selected in sheet1
3. move to 'sheet2'
4. select only cells that contains data in 'sheet2'
5. make a table using the data in 'sheet2'

Thanks.