Data arrangement

Closed
apple78 - Jan 7, 2016 at 06:48 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Jan 8, 2016 at 02:59 AM
Hello,

I have 2 sheets in an Excel workbook. I am trying to code certain cells in a pre-made template on Sheet 1 to automatically sync with my data from Sheet 2. How can I code the cells without having to input a formula for each cell?

1 response

vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 259
Jan 8, 2016 at 02:59 AM
Hello Apple,

Could you upload a sample of your work book for us please so that we can assess your situation correctly.

You can upload a sample by using a free file sharing site such as DropBox, ge.tt or SpeedyShare then post back here with the link to your file. Be careful with any sensitive data.

In the meantime, I'm assuming that your template (Sheet 1) may be an Invoice template, or similar (Order Form?) drawing its inputs from Sheet 2 preparing it for assessment/mailing.

Cheerio,
vcoolio.
0