ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   automated process within Excel (https://www.excelbanter.com/excel-programming/370508-automated-process-within-excel.html)

Silvertip[_5_]

automated process within Excel
 

Hi,

I really have no idea how to do this, but the short story is that I
have two spreadsheets within one workbook.The requirement is that when
a particular field gets filled in on Sheet1, the content of column (a)
through (d) needs to be copied to the equivalent row, column (a)
through (d) in Sheet 2.

Can someone please assist ?

Thanks


--
Silvertip
------------------------------------------------------------------------
Silvertip's Profile: http://www.excelforum.com/member.php...o&userid=28456
View this thread: http://www.excelforum.com/showthread...hreadid=572092


drawlings[_8_]

automated process within Excel
 

On Sheet 2

In Column A1 Enter =Sum(Sheet1!A1) etc...

Is this was what you are looking for?

Regard

--
drawling
-----------------------------------------------------------------------
drawlings's Profile: http://www.excelforum.com/member.php...fo&userid=3662
View this thread: http://www.excelforum.com/showthread.php?threadid=57209



All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com