Previous Topic Next Topic

Copy a single cell per sheet to another workb

Closed
Slowone Posts 1 Registration date Sunday 12 December 2010 Status Member Last seen 12 December 2010 - 12 Dec 2010 à 14:30
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 27 Dec 2010 à 09:28
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
27 Dec 2010 à 09:28
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

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Extract data from one sheet to another
phanikr -
Mazzaropi -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses