I need to collect data from different sheets on a single sheet in a workbook which have same cell no. but different sheet no. I tried it with using copy paste technique n fix the cell no. with $ but their is no change in sheet no.
plzz help me with it , is their any other formula for doing this?
Menu
Query related Excel
Replies (5)
Use = from different sheets.
Their is almost 200 something sheet it will take too time, is their any other trick or way to do this in short tym?
U can use copy special function where u can keep the values only
I tried it , it only paste the values but I want to paste formula as well with changing sheet reference and not changing cell reference
Oh.. okay here u can try
1,copy paste
2.select all where pasted
3.hen change ur sheet number using replace all to desired one.
1,copy paste
2.select all where pasted
3.hen change ur sheet number using replace all to desired one.
Recent Topics :
- Moving from old to new tax regime after notice
- Need urgent help on notice
- ITR-3 - F&O Loss adjusted against business inc
- Error - Blank Rows in Schedule SI (ITR-2)
- Dividend from co-operative society
- SECTION 139(10) OF THE COMPANIES ACT, 2013 CASE
- TDS u/s.194C returns filed in ITR-1
- TDS on Property - Form 26QB Related
- Capital gains on sale of flat from wife to husband
- TDS filing for the 1st quarter of TY 2026-27
Related Topics :
CAclubindia
