mjdalmalti
New Member
- Joined
- Mar 11, 2022
- Messages
- 9
- Office Version
- 2016
- Platform
- Windows
i have two sheet , as you see in first sheet (sheet1) there is a column first row have a serial number and second row is type
i wanna separate them from each other in second sheet to look like that
I tried to write this code in the first cell on the second sheet
and make auto fill but it does not work and make duplicated
New Microsoft Excel Worksheet.xlsx | |||
---|---|---|---|
A | |||
1 | 1234 | ||
Sheet1 |
i wanna separate them from each other in second sheet to look like that
New Microsoft Excel Worksheet.xlsx | |||
---|---|---|---|
B | |||
7 | |||
Sheet2 |
I tried to write this code in the first cell on the second sheet
Excel Formula:
=Sheet1!A1
=Sheet1!A3