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

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

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

20 responses
Formula to Find&replace blank cells in excel
onetuff_z -
tstobb -

11 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response