i am new to the forum. i am working on the excel, where we have multiple sheets with different requirements. below are the details:
Sheet1_Source data to be copied with some of the rows / columns unhided / hided as per the requirement and then to to be pasted to Sheet1_val
Sheet1_Source data to be copied to Sheet2_val entire data range to be pasted.
in short below details are given in the dimension tab
Source_tab = details of the sheet names
Destination_tab = details of the sheet names
Source_range = details of the range to be copied
Destination_range = details of the range to be pasted
unhide_rows = details of the rows range to be unhidden
hide_rows = details of the rows range to be hidden
unhide_coulmn = details of the columns range to be unhidden
hide_column = details of the column range to be hidden
for example: if there 6, then macro should work for the 6 rows details given in the dimension tab.
input workbook and output workbook are different.
Sample of the workbook as described above is enclosed for reference.
Hope macro can be prepared for the above.
Also, in the above requirement, excel to excel...is it possible to get the code to copy from excel to ppt.
In the dimension tab , giving additional information of the height, width, top, left details where the excel range to be copied in the ppt.details.xlsx
kindly let me know for more information.