Previous Topic Next Topic

Copy a single cell per sheet to another workb

Closed
Slowone Posts 1 Registration date Sunday December 12, 2010 Status Member Last seen December 12, 2010 - Dec 12, 2010 at 02:30 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 27, 2010 at 09:28 AM
Hello,

I need a macro in Excel] 2010 to copy a single cell "n18" from each sheet in workbook "A" to a corresponding cell "C19" of each sheet of workbook "B". The data pasted must be the value only. The workbooks are identical and may consist of over 70 sheets.

Any help would be greatly appreciated. I am not vba literate.

Slowone

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 27, 2010 at 09:28 AM
Hi Slowone,

A macro isn't necessary, take a look:

In workbook A, right-click on a sheet and click on "Select all sheets" to select uhm... all sheets. Now copy the contents of cell N18.
Goto workbook B, right-click on a sheet and click on "Select all sheets". Right-click on cell C19 and select paste special - values. Done

Best regards,
Trowa
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Copy data onto sheet only if cell has text
danipants -
checjb -

17 responses
Counting cells containing only numbers
jutulu -
jutulu -

4 responses