Hi Jie Jenn. Thanks I have a problem with this. If i put the Master ws as the first sheet in the wrkbk it does not copy the headers. On the other hand if i put the Master ws as the last ws it copies the other sheets data twice
Hi! I admire your tutorial as I learn lots on it. Just a question: once i copied the data set, is it possible to paste it via pastevalues? Because the first 2 columns of my data set contains formulas. And i want to paste only its values. Please i appreciate your response.
Hi. I am working with 85 worsheets daily and I want this same procedure. But my worksheets are different (it is like an invoice format). But my tables/ranges for each sheet are having the same format such as same headers, number of columns, etc. Is there a way that by using your procedure, I can specify the table or range where I need to copy the data? Like for example, I only need to copy the rows with data from I12:N32. Appreciate your response. Thanks a lot!
I didn't look at the code in the video, but I am guessing I am using ws to reference each worksheet. If that's the case, you can specify the range by adding the range method. For example, ws.Range("I12:N32")
Hi Jie Jenn. Thanks
I have a problem with this. If i put the Master ws as the first sheet in the wrkbk it does not copy the headers.
On the other hand if i put the Master ws as the last ws it copies the other sheets data twice
Hi! I admire your tutorial as I learn lots on it. Just a question: once i copied the data set, is it possible to paste it via pastevalues? Because the first 2 columns of my data set contains formulas. And i want to paste only its values. Please i appreciate your response.
Thanks bro !
Super, If want to get the data from an other file / worrkbook, how can I ask to select the file?
Hi, did u got the solution???
Hi. I am working with 85 worsheets daily and I want this same procedure. But my worksheets are different (it is like an invoice format). But my tables/ranges for each sheet are having the same format such as same headers, number of columns, etc. Is there a way that by using your procedure, I can specify the table or range where I need to copy the data? Like for example, I only need to copy the rows with data from I12:N32.
Appreciate your response. Thanks a lot!
I didn't look at the code in the video, but I am guessing I am using ws to reference each worksheet. If that's the case, you can specify the range by adding the range method. For example, ws.Range("I12:N32")