Looping through sheets finding values and saving them values on another sheet
I have a spreadsheet which has many different sheets which is growing and
reducing all the time.
There will be multiple sheets that look identical but with different data.
Cell c1 holds a date Column a holds record id Column B holds a percentage
I need to save the % against the record id and create a column with the
date as a heading in a separate sheet. If the date already exists I need
to overwrite the data in that column with the new data in the different
sheets. The date will be consistent across all spreadsheets
Any help would be appreciated
Thanks in advance
No comments:
Post a Comment