Help needed:
1.The above code works fine as per my need, as its copying from multiple workbooks there are few workbooks that have blank cells, while pasting it skips the blank cells, i want the blank cells as well(to be replaced with 0/null)
2.Am creating multiple modules & running this code many times as i want to copy different cell values(ex:N6,V14,R12) from all the workbooks, is there a way to modify the existing code instead of creating multiple modules
What am working on....i have standard excel template filled with information i want to extract information from certain cells from multiple workbooks & put it in the form of a table
P.S: Am a beginner
Bookmarks