I would like to create a macro that records data at the click of a linked button from one spreadsheet to another. The data will be calculated on multiple days, and it varies whether it will be taken on just M-F or Sat as well, so I'm looking for a way to do an if/ then statement that will match the date on one worksheet to the one on another worksheet and populate a line of data on the new sheet from various cells (like "Paste Special- Values" so it will not change every time I reuse the spreadsheet). Is there a way to say match the days on these two spreadsheets, and fill in x, y and z?
Any suggestions?
Thank you!
